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

Syntax

UPDATE_ISOLATION_LEVEL=DBMS-specific-value

See the documentation for your data source for the values for your DBMS.

The degree of isolation identifies 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 more information, see the locking topic in the appropriate data source reference in SAS Federation Server: Administrator’s Guide.