Previous Page | Next Page

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]


See Also

ERRLIMIT and LIBNAME Options


Example 1

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

Previous Page | Next Page | Top of Page