ALLBASE/SQL Reference Manual (36216-90216)

572 Chapter12

SQL Statements S - Z

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

identiﬁes a speciﬁc connection in which the 'query' to be terminated is

running.

XID

TransactionID

identiﬁes a speciﬁc 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 speciﬁed 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 speciﬁed 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