Enabling/disabling SQL interruption

The OPTIONS SQL INTERRUPT instruction enables or disables SQL statement interruption.

Syntax

OPTIONS SQL INTERRUPT { ON | OFF }

Usage

The OPTIONS SQL INTERRUPT instruction controls interruption event detection during the execution of long running SQL statements.

Pay attention to the fact that not all database servers support SQL interruption.

By default, SQL interruption is off.