UPDATE_ISOLATION_LEVEL= LIBNAME Statement Option
Specifies the degree of isolation of the current
application process from other concurrently running application processes.
| Valid in: |
LIBNAME statement |
| Default: |
data source-specific |
| Supports: |
DB2 UNIX/PC, MySQL, ODBC, Oracle, Teradata |
Syntax
UPDATE_ISOLATION_LEVEL= data
source-specific-value
Syntax Description
The values for this
option are DBMS-specific.
Details
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 ODBC and DB2 under
UNIX and PC hosts, this option is ignored if UPDATE_LOCK_TYPE= is
not set to ROW.
See Also
To apply this
option to an individual table, use the UPDATE_ISOLATION_LEVEL= data
set option.