Previous Page | Next Page

Data Set Options for Relational Databases

READ_ISOLATION_LEVEL= Data Set Option



Specifies which level of read isolation locking to use when you are reading data.
Default value: DBMS-specific
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: DB2 under UNIX and PC Hosts, DB2 under z/OS, Microsoft SQL Server, ODBC, OLE DB, Oracle, Sybase, Teradata

Syntax
Syntax Description
Details
See Also

Syntax

READ_ISOLATION_LEVEL=DBMS-specific-value

Syntax Description

dbms-specific-value

See the DBMS-specific reference section for your interface for this value.


Details

The degree of isolation defines the degree to which these items are affected:

DB2 under UNIX and PC Hosts, Netezza, ODBC: This option is ignored if you do not set READ_LOCK_TYPE=ROW.

See the locking topic for your interface in the DBMS-specific reference section for details.


See Also

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

READ_LOCK_TYPE= Data Set Option

Previous Page | Next Page | Top of Page