Data Set Options for Relational Databases |
Specifies which level of read isolation locking to use when you
are reading data.
Default value: |
DBMS-specific
|
Valid in: |
DATA and PROC steps (when accessing DBMS data
using SAS/ACCESS software)
|
DBMS support: |
DB2 under UNIX and PC Hosts, DB2 under z/OS,
Microsoft SQL Server, ODBC, OLE DB, Oracle, Sybase, Teradata
|
READ_ISOLATION_LEVEL=DBMS-specific-value
|
-
dbms-specific-value
-
See the DBMS-specific reference section
for your interface for this value.
The degree of isolation defines the degree
to which these items are affected:
-
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, Netezza, ODBC:
This option is ignored if you do not set READ_LOCK_TYPE=ROW.
See the locking topic for your interface in the DBMS-specific reference
section for details.
To
assign this option to a group of relational
DBMS tables or views, see the
READ_ISOLATION_LEVEL= LIBNAME Option.
READ_LOCK_TYPE= Data Set Option
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.