| LIBNAME Statement: PC Files on Microsoft Windows |
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 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.
To assign this option to a group of tables, use the
DBCOMMIT option specified in LIBNAME Options.
Note: If you specify both DBCOMMIT = option and an ERRLIMIT=
optionERRLIMIT, 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 ERRLIMIT = option,
the DBCOMMIT = option overrides the ERRLIMIT= option in this situation. ![[cautionend]](../../../../common/62850/HTML/default/images/cautend.gif)
/* a commit is issued after every 10 rows are inserted */
data myxls.dept(dbcommit=10);
set mysas.staff;
run;
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
