214 UPDATE_ISOLATION_LEVEL= Data Set Option Chapter 10
UPDATE_ISOLATION_LEVEL= Data Set Option
Defines the degree of isolation of the current application process from other concurrently running
application processes
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support:
DB2 OS/390, DB2 UNIX/PC, ODBC, OLE DB, Oracle, Microsoft SQL
Server, SYBASE, Teradata
Default value:
LIBNAME setting
Syntax
UPDATE_ISOLATION_LEVEL=dbms-specific-value
Syntax Description
dbms-specific-value
See the documentation for your SAS/ACCESS interface for the values for your DBMS.
Details
The degree of isolation identifies the following:
the degree to which rows that are read and updated by the current application are
available to other concurrently executing applications
the degree to which update activity of other concurrently executing application
processes can affect the current application.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “UPDATE_ISOLATION_LEVEL= LIBNAME Option” on page 130.
UPDATE_LOCK_TYPE= Data Set Option
Specifies how data in a DBMS table is locked during an update transaction
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS
software)
DBMS support: DB2 OS/390, DB2 UNIX/PC, ODBC, OLE DB, Oracle, Microsoft SQL
Server, SYBASE, Teradata
Default value: LIBNAME setting
Syntax
UPDATE_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW
