Tuesday, 24 March 2015

Export and Import command to use in datamover

Export and Import command to use in datamover:-


Export

SET OUTPUT C:\temp\tablename.dat;
SET LOG C:\temp\tablename.log;
export PS_tablename;



Import

SET LOG C:\temp\tablename.log;
SET INPUT C:\temp\tablename.dat;
import PS_tablename;


*C:\temp is location where I want to generate log and dat file. It can be any location as per your preference

No comments:

Post a Comment

The purge process did not run because the Oprid configured to start the Process Scheduler did not have the required permissions to run the purge process.

  Purge process - Required permissions The PeopleSoft Oprid used to start the Process Scheduler, as defined in the Scheduler's psprcs.cf...