READ_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 and some DBMS-specific connection options. See the DBMS-specific reference section for details.
Default:	DBMS-specific
Data source:	DB2 under UNIX and PC Hosts, DB2 under z/OS, Informix, Microsoft SQL Server, ODBC, OLE DB, Oracle, Sybase, Sybase IQ, Teradata
See:	READ_ISOLATION_LEVEL= data set option, READ_LOCK_TYPE= LIBNAME option [DBMS-specific locking information] DB2 under UNIX and PC Hosts, DB2 under z/OS, Microsoft SQL Server, ODBC, OLE DB, Oracle, Sybase, Sybase IQ, Teradata

Syntax

READ_ISOLATION_LEVEL=DBMS-specific value

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

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.

DB2 under UNIX and PC Hosts, ODBC: This option is ignored 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.