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 the cdrserver and cdrtime columns explicitly in your statement when you unload your data.
• List the columns that you want to load in the INSERT statement and explicitly include the cdrserver and cdrtime 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.