READ_ISOLATION_LEVEL= LIBNAME Statement Option
Defines the degree of isolation of the current application
process from other concurrently running application processes.
| Valid in: |
LIBNAME statement |
| Default: |
DBMS-specific |
| Supports: |
DB2 UNIX/PC, MySQL, ODBC, Oracle, Teradata |
Syntax
READ_ISOLATION_LEVEL=DBMS-specific
value
Syntax Description
See the reference documentation
for your DBMS for additional details.
Details
The degree of isolation
defines
-
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.
The ODBC and DB2 drivers
ignore this option if READ_LOCK_TYPE= is not set to ROW.
See Also
To apply this
option to an individual table, use the READ_ISOLATION_LEVEL= data
set option.