LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows

DBCOMMIT

Lets you issue a commit statement automatically after a specified number of rows have been processed.

Valid in:	DATA and PROC steps
Default value:	LIBNAME option setting

Syntax
Syntax Description
Details
Example
See Also

Syntax

DBCOMMIT=number-of-rows

Syntax Description

number-of-rows: 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. When DBCOMMIT=0, a commit is issued only once--after the procedure or DATA step completes.

If the DBCOMMIT= option is explicitly set, SAS/ACCESS fails any update that has a WHERE clause.

Note: If you specify both DBCOMMIT= and ERRLIMIT= ERRLIMIT, and these options collide during processing, then the commit is issued first and the rollback is issued second. Because the DBCOMMIT= option is issued before the rollback, the DBCOMMIT= option overrides the ERRLIMIT= option. [cautionend]

Example

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

DATA myxls.dept (DBCOMMIT=10); 
  SET mysas.staff;
RUN;