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
|
DBMS support: |
DB2 under UNIX and PC Hosts, DB2 under z/OS,
Microsoft SQL Server, ODBC, OLE DB, Oracle, Sybase, Sybase IQ, Teradata
|
UPDATE_ISOLATION_LEVEL=DBMS-specific-value
|
The
values for this option are DBMS-specific. See the DBMS-specific reference
section for 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 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.
To
apply this option to an individual data set, see
the
UPDATE_ISOLATION_LEVEL= Data Set Option.
UPDATE_LOCK_TYPE= LIBNAME Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.