Previous Page | Next Page

The LIBNAME Statement for Relational Databases

AUTOCOMMIT= LIBNAME Option



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

Syntax
Syntax Description
Details
See Also

Syntax

AUTOCOMMIT=YES | NO

Syntax Description

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.


Details

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.


See Also

To apply this option to an individual data set, see the AUTOCOMMIT= Data Set Option.

Previous Page | Next Page | Top of Page