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:	LIBNAME option default: 1000

Syntax

Details

Example

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.

Example: Issue Automatic Commit Statement

/* a commit is issued after every 10 rows are inserted */
DATA  myxls.dept(DBCOMMIT=10);
 SET mysas.staff;
RUN;

DBCOMMIT

Syntax

Syntax Description

Details

Example: Issue Automatic Commit Statement

See Also