Following
Export and Import DMS script can be used for the beginner who is new to use DMS
to export data from PeopleSoft records.
DMS to Export Data and create DAT file:
SET LOG C:\Temp\TEST_TABLE_EXPORT.log;
SET OUTPUT C:\Temp\TEST_TABLE_DATA.DAT;
EXPORT PS_TEST_TABLE WHERE
LASTUPDDTTM <= SYSDATE();
DMS to Import data from DAT file:
SET LOG C:\Temp\TEST_TABLE_IMPORT.log;
SET INPUT C:\Temp\TEST_TABLE_DATA.DAT;
IMPORT PS_TEST_TABLE ;
Good work Bhai
ReplyDeleteManoj
It helped. Thanks!!
ReplyDeleteCan we export it to a new table instead of a .DAT file?
ReplyDeleteIs it possible to append a sysdate or timestamp to the output file name?
ReplyDeleteEXAMPLE - SET OUTPUT E:\Temp\output_('sysdate' or 'timestamp').DAT;