DataMover Commands

REPLACE_DATA: It truncates the data first, and then imports the data. If the table doesn’t exist, then we get an error.

Syntax:

SET INPUT E:/ABC.DAT;

REPLACE_DATA *;

Note: No need of giving IMPORT command. It will truncate the table and import the data automatically.

REPLACE_ALL: It will drop the table, recreate it and import the data.

IGNORE_DUPS: command to ignore the duplicate rows and inserts the new rows. We can use this command only in Bootstrap mode.

SET OUTPUT E:\ABC.DAT;

Export PSOPTIONS;

-------******--------********

UDDATE_DUPS: UPDATE_DUPS imports a new row and updates an existing row. This command is valid for both bootstrap mode and regular mode.

-------------*************----------------

SET INPUT E:/ABC.DAT;

SET IGNORE_DUPS;

IMPORT *;