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 a text file and the LOAD instruction inserts rows from a text file into a database table.

Microsoft™ SQL SERVER has LOAD and UNLOAD instructions, but those commands are related to database backup and recovery. Do not confuse with Informix commands.

Solution

LOAD and UNLOAD instructions are supported; note the following;