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)
Default:	DBMS-specific
Data source:	DB2 under UNIX and PC Hosts, DB2 under z/OS, Microsoft SQL Server, ODBC, OLE DB, Oracle, Sybase, Teradata
See:	READ_ISOLATION_LEVEL= LIBNAME option, READ_LOCK_TYPE= data set option. See also locking information for DB2 under UNIX and PC Hosts, DB2 under z/OS, Microsoft SQL Server, ODBC, OLE DB, Oracle, Sybase, Sybase IQ, Teradata.

Syntax

READ_ISOLATION_LEVEL=DBMS-specific-value

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

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

rows that are read and updated by the current application are available to other concurrently executing applications
update activity of other concurrently executing application processes can affect the current application

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.