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.
