Previous Page | Next Page

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
Syntax Description
See Also

Syntax

AUTOCOMMIT=YES | NO

Syntax Description

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.


See Also

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

DBCOMMIT= Data Set Option

Previous Page | Next Page | Top of Page