OR_ENABLE_INTERRUPT= LIBNAME Option

Allows interruption of any long-running SQL processes on the DBMS server.
Valid in: SAS/ACCESS LIBNAME statement
Default: NO
Data source: Oracle

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

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