SQL adaptation guide for IBM Netezza 6.x / BDL programming |
Informix® provides two SQL instructions to export / import data from / into a database table: The UNLOAD instruction copies rows from a database table into a text file and the LOAD instructions insert rows from a text file into a database table.
Netezza® does not provide LOAD and UNLOAD instructions, but provides external tools like the nzload utility.
LOAD and UNLOAD instructions are supported.