TERMINATE QUERY
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 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
|
STOP DBE |
TERMINATE TRANSACTION |