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 UNIX/PC, MySQL, ODBC, Oracle, Teradata

Syntax

READ_ISOLATION_LEVEL=DBMS-specific-value

Syntax Description

dbms-specific-value
See the documentation for your data source for the values for your DBMS.

Details

The ODBC and DB2 drivers ignore this option if READ_LOCK_TYPE= is not set to ROW.
The degree of isolation defines 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.
For additional information, see the locking topic in the appropriate data source reference in the DataFlux Federation Server Administrator’s Guide.