REPLACE

Restriction: This topic applies to Windows environments only.

Specifies whether the data being imported is to be appended to existing data in the table or is to replace it. The syntax is:

REPLACE = {Y | N};

If REPLACE is set to N (default), the imported data will appended to the existing data. If REPLACE is set to Y, the imported data will replace the data in the table.

This command is ignored if the named table does not exist; a new table is then created. The default is to append the data to the end of existing data in the table if found. REPLACE is an optional Batch Import command.

For example:

REPLACE  = N;

will append data to an existing table.