UPDATE_ISOLATION_LEVEL= LIBNAME Option

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

Valid in:	SAS/ACCESS LIBNAME statement
Default:	DBMS-specific
Restriction:	This option is ignored in the interfaces to ODBC and DB2 under UNIX and PC Hosts if you do not set UPDATE_LOCK_TYPE=ROW.
Data source:	DB2 under UNIX and PC Hosts, DB2 under z/OS, Microsoft SQL Server, ODBC, OLE DB, Oracle, Sybase, Sybase IQ, Teradata
See:	UPDATE_ISOLATION_LEVEL= data set option, UPDATE_LOCK_TYPE= LIBNAME optionUPDATE_LOCK_TYPE= data set option [DBMS-specific locking details] 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

The values for this option are DBMS-specific. See the DBMS-specific reference section for details.

The degree of isolation defines the degree to which:

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.

This option is ignored in the interfaces to DB2 under UNIX and PC Hosts and ODBC if you do not set UPDATE_LOCK_TYPE=ROW.

See the locking topic for your interface in the DBMS-specific reference section for details.