The LOAD and UNLOAD instructions

Informix® provides two SQL instructions to export / import data from / into a database table: The UNLOAD instruction copies rows from a database table into an text file, and the LOAD instruction inserts rows from an text file into a database table.

IBM® DB2® does not provide LOAD and UNLOAD instructions.

Solution

LOAD and UNLOAD instructions are supported.

Note: There is a difference when using DB2 TIME and TIMESTAMP columns: TIME columns created in the IBM DB2 database are similar to Informix DATETIME HOUR TO SECOND columns. In LOAD and UNLOAD, all DB2 TIME columns are treated as Informix DATETIME HOUR TO SECOND columns and thus will be unloaded with the "hh:mm:ss" format.