AUTOCOMMIT= LIBNAME Option

Indicates whether updates are committed immediately after they are submitted.

Valid in:	SAS/ACCESS LIBNAME statement and some DBMS-specific connection options. See the DBMS-specific reference section for details.
Default:	DBMS-specific
Data source:	Aster nCluster, DB2 under UNIX and PC Hosts, Greenplum, HP Neoview, Informix, Microsoft SQL Server, MySQL, Netezza, ODBC, OLE DB, Sybase, Sybase IQ
See:	AUTOCOMMIT= data set option

Syntax

Details

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.