Data Set Options for Relational Databases

AUTOCOMMIT= Data Set Option

Specifies whether to enable the DBMS autocommit capability.

Default value:	LIBNAME setting
Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support:	MySQL, Sybase

Syntax

AUTOCOMMIT=YES | NO

YES: specifies that all updates, inserts, and deletes are committed immediately after they are executed and no rollback is possible.
NO: specifies that SAS performs the commit after processing the number of row that are specified by using DBCOMMIT=, or the default number of rows if DBCOMMIT= is not specified.

To assign this option to a group of relational DBMS tables or views, see the AUTOCOMMIT= LIBNAME Option.