TERMINATE TRANSACTION
MPE documents | |
 Complete PDF | |
| Table of Contents | |
| Index | |
| E0300 Edition 9 ♥ | |
| E0399 Edition 8 | |
| E0897 Edition 7 |
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
|
TERMINATE QUERY |
TERMINATE USER |