Data Mover Commands

Data Mover Commands

CHANGE_ACCESS_PASSWORD <symbolic_id> <newAccessPswd>

ENCRYPT_PASSWORD

ENCRYPT_PASSWORD <User_id>;
ENCRYPT_PASSWORD *;

IMPORT

IMPORT <table_name> As <new_tablename>;
IMPORT * AS <table_name> WHERE <condition>;
IMPORT *;

EXPORT

EXPORT <table_name> WHERE <condition>;
EXPORT *;

REPLACE_ALL

REPLACE_ALL <record_name>;
REPLACE_DATA *;

REPLACE_DATA

REPLACE_DATA <record_name>;
REPLACE_DATA *;

REPLACE_VIEW

REPLACE_VIEW <view_name>;
REPLACE_DATA *;

SET

SET LOG <log_file>;
SET OUTPUT <file_name>;
SET INPUT <file_name>;
SET IGNORE_ERRORS;
SET IGNORE_DUPS;
SET COMMIT;
SET UPDATE_DUPS;