Loading a Target Table
Informix XPS Load supports the following three values of the Load Action property for loading a target table.
For an explanation of how IBM® InfoSphere® DataStage® columns are translated into Informix columns, see Creating the Target Table.
- TRUNCATE. This default value deletes all existing rows from the table before starting the load.
- CREATE. Informix XPS Load creates the table on the target database. It supports table creation using properties that specify table type, fragmentation strategies, and storage allocation.
- APPEND. This value loads its data regardless of whether the target table already contains data. Constraint violations may result. However, any rejected rows are written to a configurable reject file.
For more information about the Load Action property, see Properties.