Previous Page | Next Page

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.

Previous Page | Next Page | Top of Page