Data Set Options for Relational Databases |
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 |
Syntax | |
Syntax Description | |
Details | |
See Also |
Syntax |
UPDATE_ISOLATION_LEVEL=DBMS-specific-value |
See the documentation for your SAS/ACCESS interface for the values for your DBMS.
Details |
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.
See Also |
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.