we want run query in netezza ide , export results in form of csv file. there api let same, using shell or other script?
is there shell available netezza knows about, using can run sql query , results in text file or csv file (preferred)?
since have powershell among tags, assuming need tool works under windows. command line client netezza - nzsql - not available windows there couple of third-party command line sql clients/shells can use with netezza:
- jisql, jdbc client; parameters same in squirrel
- dbish, perl-based odbc client; if odbc dsn called nz, command line be
dbish dbi:odbc:nz user password
both tools have options output results csv files.
Comments
Post a Comment