UPDATE_ISOLATION_LEVEL= Data Set Option

Specifies the degree of isolation of the current application process from other concurrently running application processes.
Valid in: DATA and PROC steps
Default: LIBNAME statement setting
Supports: DB2 UNIX/PC, MySQL, ODBC, Oracle, Teradata

Syntax

UPDATE_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 degree of isolation identifies 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.