The LIBNAME Statement for Relational Databases |
Indicates
whether updates are committed immediately after they
are submitted.
Default value: |
DBMS-specific (see "Details")
|
Valid in: |
SAS/ACCESS LIBNAME
statement and some DBMS-specific connection options. See the DBMS-specific
reference section for details.
|
DBMS support: |
Aster nCluster, DB2 under
UNIX and PC Hosts, Greenplum, HP Neoview, Informix, Microsoft SQL Server,
MySQL, Netezza, ODBC, OLE DB, Sybase, Sybase IQ
|
-
YES
-
specifies that all updates, deletes, and
inserts are committed (that is, saved to a table) immediately after they are
submitted, and no rollback is possible.
-
NO
-
specifies that the SAS/ACCESS engine
automatically performs the commit when it reaches the DBCOMMIT= value, or
the default number of rows if DBCOMMIT is not set.
If you are using the SAS/ACCESS LIBNAME
statement, the default is NO if the data source provider supports transactions
and the connection is to update data.
Informix, MySQL: The default is YES.
Netezza: The default is YES for PROC PRINT but NO for updates
and for the main LIBNAME connection. For read-only connections and the SQL
pass-through facility, the default is YES.
To apply this option to an individual data set, see
the AUTOCOMMIT= Data Set Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.