This section contains information that is specific to the database type Netezza.

 Supported Functions

 The Netezza database can be used with:

...

 For data loading, it is recommended that you use the SQL Loader Agent. You can also use APL function sqlExec for both data loading and unloading. For information on how to use sqlExec with Netezza see the section below, APL Examples. For further details, see also the IBM Netezza Data Loading Guide.

 Preparations

 This section describes preparations that you must perform before attempting to connect to a Netezza database.

 A driver, provided by your IBM contact, is required to access the Netezza database. This driver must be stored on each host (Platform or EC) that will connect to a Netezza database.

For Image Added to access the Netezza database, follow the steps below:
 

...

APL Examples

This section gives examples of how to use the APL function sqlExec with a Netezza Database profile.

...

initialize {
 int rowcount = sqlExec("NETEZZA.NetezzaProfile", 
 "CREATE EXTERNAL TABLE '/tmp/test.csv' 
 USING (DELIM ',' REMOTESOURCE 'JDBC') 
 AS SELECT * FROM mytable");
}