The LIBNAME Statement for Relational Databases

READ_ISOLATION_LEVEL= LIBNAME Option

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

Default value:	DBMS-specific
Valid in:	SAS/ACCESS LIBNAME statement and some DBMS-specific connection options. See the DBMS-specific reference section for details.
DBMS support:	DB2 under UNIX and PC Hosts, DB2 under z/OS, Informix, Microsoft SQL Server, ODBC, OLE DB, Oracle, Sybase, Sybase IQ, Teradata

Syntax
Syntax Description
Details
See Also

Syntax

READ_ISOLATION_LEVEL=DBMS-specific value

Syntax Description

See the documentation for your SAS/ACCESS interface for the values for your DBMS.

Details

Here is what 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
the degree to which update activity of other concurrently executing application processes can affect the current application

This option is ignored in the DB2 under UNIX and PC Hosts and ODBC interfaces if you do not set the READ_LOCK_TYPE= LIBNAME option to ROW. See the locking topic for your interface in the DBMS-specific reference section for details.