LIBNAME Statement: PC Files on Linux, UNIX, and 64-Bit Microsoft Windows |
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
|
- number-of-rows
-
is an integer greater than or equal to 0.
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]](../../../../common/63294/HTML/default/images/cautend.gif)
In this example, a commit is issued after every 10 rows are inserted:
DATA myxls.dept (DBCOMMIT=10);
SET mysas.staff;
RUN;
To assign this option to a group of tables, use the DBCOMMIT= option
specified in LIBNAME Options.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.