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 under UNIX and 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 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 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.