LIBNAME Statement: PC Files on Microsoft Windows

DBCOMMIT

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

Valid in:	DATA and PROC steps (when accessing PC files data using SAS/ACCESS software)
Default value:	LIBNAME option default: 1000

Syntax
Syntax Description
Details
See Also
Example 1

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 the DBCOMMIT= option and the ERRLIMIT= option, and these options collide during processing, then the DBCOMMIT = option is issued first and the rollback is issued second. Because the DBCOMMIT= option is issued before the ERRLIMIT = option, the DBCOMMIT= option overrides the ERRLIMIT= option in this situation. [cautionend]