Data Set Options for Relational Databases |
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 |
Syntax | |
Syntax Description | |
Details | |
See Also |
Syntax |
READ_ISOLATION_LEVEL=DBMS-specific-value |
Details |
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.
See Also |
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.