DBCOMMIT=

DBCOMMIT=

Enables you to issue a DBMS commit statement automatically after a specified number of rows have been processed.

Default value: 1000

See Also: ERRLIMIT=

Syntax
Details

Syntax

DBCOMMIT=n

n: is an integer greater than or equal to 0.

Details

DBCOMMIT= affects update, delete, and insert processing. The number of rows processed includes rows that are not processed successfully. Beginning in Version 8, the default value of DBCOMMIT= is 1000. If you set DBCOMMIT=0, a commit is issued only once after the procedure or DATA step completes.

In the following example, a commit is issued after every 10 rows are inserted:

data oracle.dept(dbcommit=10); 
   set myoralib.staff;
run;

The DBCOMMIT= option overrides the ERRLIMIT= option. This means that a commit can be issued prior to a rollback that is needed by the ERRLIMIT= option.

Chapter Contents
Previous
Next
Top of Page