Data Set Options for Relational Databases |
Defines the degree of isolation of the current application process
from other concurrently running application processes.
Default value: |
LIBNAME setting
|
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, MySQL, ODBC, OLE DB, Oracle, Sybase, Teradata
|
UPDATE_ISOLATION_LEVEL=DBMS-specific-value
|
- dbms-specific-value
-
See the documentation for your SAS/ACCESS
interface for the values for your DBMS.
The degree of isolation identifies the degree to which:
-
the 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.
See the SAS/ACCESS documentation
for your DBMS for additional, DBMS-specific details about locking.
To
assign this option to a group of relational DBMS tables
or views, see the UPDATE_ISOLATION_LEVEL= LIBNAME Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.