The LIBNAME Statement for Relational Databases |
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 |
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.
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.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.