UNLOAD and LOAD Statements

The UNLOAD and LOAD statements allow you to move data within the context of an SQL program.

If the table contains shadow columns, you must:
  • Include all shadow columns in your map when you unload the data.
  • List the columns that you want to load in the INSERT statement and explicitly include the shadow columns in the list when you load your data.

For more information about the UNLOAD and LOAD statements, see the IBM® Informix® Guide to SQL: Syntax.

Parent topic: Load and unload data