READ_ISOLATION_LEVEL= LIBNAME Statement Option

Defines the degree of isolation of the current application process from other concurrently running application processes.

Valid in: LIBNAME statement
Default: DBMS-specific
Supports: DB2 under UNIX and PC, MySQL, ODBC, Oracle, Teradata
Syntax
Syntax Description
Details
See Also

Syntax

READ_ISOLATION_LEVEL= DBMS-specific value

Syntax Description

See the reference documentation for your DBMS for additional details.

Details

The degree of isolation defines the following degrees:
  • the degree to which rows that are read and updated by the current application are available to other concurrently executing applications
  • the degree to which update activity of other concurrently executing application processes can affect the current application.
The ODBC and DB2 drivers ignore this option if READ_LOCK_TYPE= is not set to ROW.

See Also

To apply this option to an individual table, use the READ_ISOLATION_LEVEL= data set option.
Copyright © SAS Institute Inc. All Rights Reserved.