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.