Netezza Data Load using NZLOAD

NZLoad

Its a SQL CLI command that you can use to load data from the local host or a remote client.
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 client application. The user name specifies an account with a particular set of privileges, and the system uses this account to verify access.

Permission required to run NZLoad - Create External Table permission.

NZLoad Syntax

nzload [-h|-rev] [options] 

You can used various parameters for NZLoad, some imp parameters are
-Cf - Control file is important when you are planning to load multiple files to different tables
-df - data file path
-bf - bad file path
etc

For details you can refer to Netezza 7.2.1 documentation in IBM knowledge center.