84 DBCOMMIT= LIBNAME Option Chapter 9
DBCOMMIT= LIBNAME Option
Causes an automatic COMMIT (a permanent writing of data to the DBMS) after a specified number
of rows have been processed
Valid in: the SAS/ACCESS LIBNAME statement
DBMS support:
DB2 OS/390, DB2 UNIX/PC, Informix, ODBC, OLE DB, Oracle, Microsoft
SQL Server, SYBASE, Teradata
Default value:
1000 when inserting rows into a DBMS table; 0 when updating a DBMS
table
Syntax
DBCOMMIT=n
Syntax Description
n
is an integer greater than or equal to 0.
Details
DBCOMMIT= affects update, delete, and insert processing. The number of rows that are
processed includes rows that are not processed successfully. If you set 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 prior to
the ROLLBACK (caused by the ERRLIMIT= option), the DBCOMMIT= option is said to
override the ERRLIMIT= option in this situation.
DB2 UNIX/PC Details: When BULKLOAD=YES, the default is 10000.
See Also
To apply this option to an individual data set, see the data set option “DBCOMMIT=
Data Set Option” on page 170.
DBCONINIT= LIBNAME Option
Specifies a user-defined initialization command to be executed immediately after ever y connection
to the DBMS that is within the scope of the LIBNAME statement or libref
Valid in: the SAS/ACCESS LIBNAME statement
