nzload command

The nzload command is an SQL CLI client application that you can use to load data from the local host or a remote client, on all supported client platforms, into a Netezza system.

The nzload command processes command-line load options to send queries to the host to create an external table definition, run the insert or select query to load data, and when the load is complete, drop the external table.

The nzload command connects to a database with a database user name and password, like any other Netezza Performance Server client application. The user name specifies an account with a particular set of privileges, and the system uses this account to verify access.

Although you can use the nzload command as an ODBC client application, it does not require or work with Data Source Name (DSN). It bypasses the ODBC Driver Manager and connects directly to the Netezza Performance Server ODBC driver.