Can I export the SQL query results from Netezza?

We want to run a query in the Netezza IDE and export the results in the form of a CSV file. Is there any API which would let us do the same, using a shell or some other script?

Is there any shell available with Netezza which anyone knows about, using which I can run an SQL query and get the results in a text file or a CSV file (preferred)?

Solution

Since you have powershell among your tags, I am assuming you need a tool that works under Windows. The command line client for Netezza - nzsql - is not available for Windows but there is a couple of third-party command line sql clients/shells which you can use with with Netezza:

jisql, JDBC client; the parameters are the same as in SQuirreL
dbish, a perl-based ODBC client; if your ODBC DSN is called NZ, the command line would be

dbish dbi:ODBC:NZ user password

Both tools have options to output results as CSV files.

Invalid operands found for operator -eq
Detect when user cancels $host.ui.promptforchoice prompt
How can I make sure Powershell will correctly render all non-latin characters into the output?
How can I choose between $MyInvocation.ScriptName and $MyInvocation.PSCommandPath in PowerShell?
Azure pipeline template: dynamically retrieve and story keyvault secrets
Maintaining property order with get-member
PowerShell - Return an array of all possible properties for an ADObject
List objects vs. Arrays in PowerShell
Using start-process in a loop, where some programs will have arguments and some don't; Way to not have if $Arguments -ne $null
Run Invoke-Command in remote computer as administrator
Authenticate to Azure with certificate from Linux
How to recursively append to file name in powershell?
Mapped network drives are not showing in My Computer
Delete files in a folder except a list of extensions I specify
How to open 'This PC' using CMD or Powershell?
transfer the files from sub folder and sub folders recursively without specifying the folder name
Im creating a VM using terraform code in GCP. I would like to inject a script that runs when the vm is created upon startup
Remove-ItemProperty does not seem to work with -LiteralPath
How can I elevate Powershell while keeping the current working directory AND maintain all parameters passed to the script?
How do I remove or replace a built in alias in powershell?
Remove-AdObject with Import-CSV error
What is ScopedItemOptions?
Use additional arguments to start-process Powershell -verb runas
PowerShell and M2MQTT
Invoke-Command Robocopy
npm install doesn't work in Windows PowerShell
Use CTRL + D to exit and CTRL + L to cls in Powershell console
Run a [Code] or PowerShell script in Inno Setup compiler
Calculating SHA1 hash algorithm in PowerShell V2.0
Use wildcard characters with Neo4j admin