Specifies whether to enable the DBMS autocommit capability.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Data Set Control |
| Default: | LIBNAME option value |
| Data source: | SAP ASE |
| See: | AUTOCOMMIT= LIBNAME option, DBCOMMIT= data set option |
Table of Contents
specifies that SAS commits all updates, inserts, and deletes immediately after they are executed and that no rollback is possible.
specifies that SAS commits after processing the number of rows that DBCOMMIT= specifies. If you do not specify DBCOMMIT=, SAS commits after processing the default number of rows.