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

CIDConnectionID: identifies a specific connection in which the 'query' to be terminated is running.
XIDTransactionID: 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