READ_ISOLATION_LEVEL= Data Set Option

Specifies which level of read isolation locking to use when you are reading data.

Valid in:	DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Category:	Data Set Control
Alias:	RIL= [Greenplum, HAWQ, Microsoft SQL Server, SAP IQ]
Default:	LIBNAME option value
Interaction:	This option is ignored if you do not specify READ_LOCK_TYPE=ROW. [DB2 under UNIX and PC Hosts, Netezza, ODBC]
Data source:	DB2 under UNIX and PC Hosts, DB2 under z/OS, Greenplum, HAWQ, Microsoft SQL Server, ODBC, OLE DB, Oracle, SAP ASE, Teradata, Vertica
See:	READ_ISOLATION_LEVEL= LIBNAME option, READ_LOCK_TYPE= LIBNAME option, READ_LOCK_TYPE= data set option, UPDATE_ISOLATION_LEVEL= LIBNAME option, UPDATE_ISOLATION_LEVEL= data set option, UPDATE_LOCK_TYPE= LIBNAME option, UPDATE_LOCK_TYPE= data set option, and DBMS-specific locking information in the reference section for your SAS/ACCESS interface

Table of Contents

Syntax

READ_ISOLATION_LEVEL=DBMS-specific-value

See the DBMS-specific reference section for your interface for this value.

The degree of isolation specifies the degree to which these items are affected:

Rows that the current application reads and updates are available to other concurrently executing applications.
Update activity of other concurrently executing application processes can affect the current application.

Last updated: February 3, 2026