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 |
