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.