Data Set Options for Relational Databases |
Specifies whether to enable the DBMS autocommit capability.
Default value: |
LIBNAME setting
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
MySQL, Sybase
|
-
YES
-
specifies that all updates, inserts, and
deletes are committed immediately after they are executed and no rollback
is possible.
-
NO
-
specifies that SAS performs the commit after
processing the number of row that are specified by using DBCOMMIT=, or the
default number of rows if DBCOMMIT= is not specified.
To assign this option to a
group of relational
DBMS tables or views, see the
AUTOCOMMIT= LIBNAME Option.
DBCOMMIT= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.