OR_ENABLE_INTERRUPT= LIBNAME Statement Option

Allows interruption of any long-running SQL processes on the DBMS server.

Valid in: SAS/ACCESS LIBNAME statement
Category: Data Set Control
Default: NO
Data source: Oracle

Table of Contents

Syntax

OR_ENABLE_INTERRUPT=YES | NO

Syntax Description

YES

allows interruption of long-running SQL processes on the DBMS server.

NO

disables interruption of long-running SQL processes on the DBMS server.

Details

OR_ENABLE_INTERRUPT enables you to interrupt long-running queries that you submitted through the SAS interface. You can use this option to interrupt these statements:

  • any SELECT SQL statement that was submitted by using the SELECT * FROM CONNECTION as a pass-through statement
  • any statement other than the SELECT SQL statement that you submitted by using the EXECUTE statement as a pass-through statement
Last updated: February 3, 2026