...

 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 Removed to MediationZone to access the Netezza database, follow the steps below:

1. Copy the Netezza files to the directory MZ_HOME/3pp in the Platform or EC.

2. Restart the Platform and EC for the change to take effect.

...

APL

...

Examples

...

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", 
 "INSERT INTO mytable 
 SELECT * FROM EXTERNAL '/tmp/test.csv' USING (delim ',')");
}

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

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

...