 |
|
| The DBLOAD Procedure for Relational Databases |
COMMIT= Statement
Issues a commit or saves rows after a specified number of inserts
| Default: | 1000 |
| COMMIT=commit-frequency; |
| Details |
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.