206 READ_ISOLATION_LEVEL= Data Set Option Chapter 10
READ_ISOLATION_LEVEL= Data Set Option
Specifies which level of read isolation locking to use when you are reading data
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:
DBMS-specific
Syntax
READ_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
In the interfaces to ODBC and DB2 UNIX/PC, this option is ignored if
READ_LOCK_TYPE= is not set to ROW.
The degree of isolation defines the following:
the degree with which rows that are read and updated by the current application
are available to other concurrently executing applications
the degree with 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 “READ_ISOLATION_LEVEL= LIBNAME Option” on page 118.
READ_LOCK_TYPE= Data Set Option
Specifies how data in a DBMS table is locked during a read 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: DBMS-specific
Syntax
READ_LOCK_TYPE=ROW | PAGE | TABLE | NOLOCK | VIEW
