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