AUTOCOMMIT= LIBNAME Statement Option

Indicates whether updates are committed immediately after they are submitted.
Valid in: LIBNAME statement
Supports: DB2 UNIX/PC, Greenplum, ODBC, MySQL

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 commit operation is automatically performed when processing reaches the DBCOMMIT= value, or the default number of rows if DBCOMMIT is not set.

Details

The default is NO if the data source supports transactions and the connection is used for updating data.
For MySQL, the default is YES.