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