The DBLOAD Procedure for Relational Databases |
Issues a commit or saves rows after a specified number of
inserts
The COMMIT= statement issues a commit (that is, generates
a DBMS-specific SQL COMMIT statement) after the specified number of rows has
been inserted.
Using this statement might improve performance by releasing
DBMS resources each time the specified number of rows has been inserted.
If you omit the COMMIT= statement, a commit is issued
(or a group of rows is saved) after each 1,000 rows are inserted and after
the last row is inserted.
The commit-frequency argument
must be a nonnegative integer.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.