COMMIT=

COMMIT=

Issues a commit or saves rows after a specified number of inserts.

Optional statement

Default: 1000

Syntax
Details

Syntax

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.

The commit-frequency argument must be a nonnegative integer. To commit or save observations only after all the rows have been inserted, specify COMMIT=0.

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.

An editing statement, such as COMMIT=, must be specified after the database connection statements when you create and load a DBMS table. See LOAD for more information.

Chapter Contents
Previous
Next
Top of Page