138 AUTOCOMMIT= Data Set Option Chapter 10
DBMS support: DB2 OS/390
Default value:
LIBNAME setting
Syntax
AUTHID=authorization-ID
Syntax Description
authorization-ID
is limited to 8 characters.
Details
If you specify a value for the AUTHID= option, the table name is qualified as
authid.tablename before any SQL code is passed to the DBMS. If AUTHID= is not
specified, the table name is not qualified before it is passed to the DBMS, and the
DBMS uses your user ID as the qualifier. If you specify AUTHID= in a SAS/SHARE
LIBNAME, the ID of the active server is the default ID.
SCHEMA= is an alias for this option.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “AUTHID= LIBNAME Option” on page 69.
AUTOCOMMIT= Data Set Option
Specifies whether to enable the DBMS autocommit capability
Valid in:
DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
SYBASE
Default value:
LIBNAME setting
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
