COMMIT statement usage in PeopleSoft Data Mover
PeopleSoft Data Mover issues COMMIT statements after most successful SQL commands, except for EXPORT and IMPORT commands. But for EXPORT and IMPORT commands, PeopleSoft Data Mover issues a COMMIT after each record. With IMPORT commands you can associate a SET COMMIT n command, which will perform a COMMIT after the system inserts every n rows.
Example:
SET INPUT C:\PS_CUSTOMER.dat;
SET COMMIT 5000;
IMPORT *;
The example shows that it will import all the data from PS_CUSTOMER.dat file and it will commit the data after every 5000 rows are inserted into PeopleSoft record.