| The LIBNAME Statement for 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.
Note: If you specify both DBCOMMIT= and ERRLIMIT=,
and these options collide during processing, then the commit is issued first
and the rollback is issued second. Because the commit (caused by the DBCOMMIT=
option) is issued before the rollback (caused by the ERRLIMIT= option), the
DBCOMMIT= option is said to override the ERRLIMIT= option in this situation. ![[cautionend]](../../../../common/61925/HTML/default/images/cautend.gif)
In the following 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 for PC Files on Microsoft Windows.
Copyright © 2007 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
