UPDATE_ISOLATION_LEVEL= Data Set Option

Defines the degree of isolation of the current application process from other concurrently running application processes.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Default:	LIBNAME setting
Data source:	DB2 under UNIX and PC Hosts, DB2 under z/OS, Microsoft SQL Server, MySQL, ODBC, OLE DB, Oracle, Sybase, Teradata
See:	UPDATE_ISOLATION_LEVEL= LIBNAME option, UPDATE_LOCK_TYPE= LIBNAME optionUPDATE_LOCK_TYPE= data set option. See also locking information for DB2 under UNIX and PC Hosts, DB2 under z/OS, Microsoft SQL Server, ODBC, OLE DB, Oracle, Sybase, Teradata.

Syntax

UPDATE_ISOLATION_LEVEL=DBMS-specific-value

dbms-specific-value: See the documentation for your SAS/ACCESS interface for the values for your DBMS.

The degree of isolation identifies the degree to which:

the rows that are read and updated by the current application are available to other concurrently executing applications.
update activity of other concurrently executing application processes can affect the current application.

See the SAS/ACCESS documentation for your DBMS for additional, DBMS-specific details about locking.