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
Default:	DBMS-specific
Supports:	DB2 under UNIX and PC, MySQL, ODBC, Oracle, Teradata

Syntax

READ_ISOLATION_LEVEL=DBMS-specific-value

See the documentation for your data source for the values for your DBMS.

The ODBC and DB2 drivers ignore this option if READ_LOCK_TYPE= is not set to ROW.

The degree of isolation defines the following degrees:

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.

For more information, see the locking topic in the appropriate data source reference in SAS Federation Server: Administrator’s Guide.