Previous Page | Next Page

Data Set Options for Relational Databases

UPDATE_ISOLATION_LEVEL= Data Set Option



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

Syntax
Syntax Description
Details
See Also

Syntax

UPDATE_ISOLATION_LEVEL=DBMS-specific-value

Syntax Description

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:

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.

Previous Page | Next Page | Top of Page