HP 3000 Manuals

ALLBASE/SQL Reference Manual

TERMINATE QUERY 

The TERMINATE QUERY statement terminates a running QUERY.

Scope 

ISQL or Application Programs

SQL Syntax 

TERMINATE QUERY FOR {CID ConnectionID }
                    {XID TransactionID}
Parameters 

CID ConnectionID        identifies a specific connection in which the
                        'query' to be terminated is running.

XID TransactionID       identifies a specific transaction in which the
                        'query' to be terminated is running.

Description 

   *   A 'query' in this case refers to a command being executed.

   *   The current command in progress for the specified connection or
       transaction is terminated and any changes are backed out.

Authorization 

You can terminate a query, if it is your own query, or if you have DBA
authority.  Also the TERMINATE AT QUERY LEVEL option must have been set
for the specified connection or transaction.  See SET TRANSACTION or SET
SESSION for more information on the TERMINATE AT QUERY LEVEL option.

Example 

      TERMINATE QUERY FOR CID ConnectionID3 
[REV END][REV BEG]

MPE/iX 5.5 Documentation