ALLBASE/SQL Reference Manual (36216-90216)

Chapter 12 573
SQL Statements S - Z
TERMINATE TRANSACTION
TERMINATE TRANSACTION
The TERMINATE TRANSACTION statement terminates a given transaction.
Scope
ISQL or Application Programs
SQL Syntax
TERMINATE TRANSACTION FOR {CID ConnectionID
XID TransactionID }
Parameters
CID ConnectionID identifies the specific connection in which the transaction to be
terminated is running.
XID
TransactionID identifies a specific transaction to be terminated.
Description
• The transaction in progress for the connection is terminated and any changes are
backed out.
Authorization
You can terminate a transaction if it is your own transaction, or if you have DBA authority.
Also the TERMINATE AT QUERY LEVEL or TERMINATE AT TRANSACTION LEVEL
option must have been set for the specified connection or transaction. See SET
TRANSACTION or SET SESSION for more information on these options.
Example
TERMINATE TRANSACTION FOR CID ConnectionID3