The LIBNAME Statement for Relational Databases |
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
|
READ_ISOLATION_LEVEL=DBMS-specific value
|
See
the documentation for your SAS/ACCESS interface
for the values for your DBMS.
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.
To
apply this option to an individual data set, see
the
READ_ISOLATION_LEVEL= Data Set Option.
READ_LOCK_TYPE= LIBNAME Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.