Cancels a query being processed by the Advantage Query Engine.
Syntax
sp_CancelQuery( Query Number, Integer );
Parameters
Query Number (I) |
Number of the query to cancel. The query number is returned by sp_GetSQLStatements. |
Output
None.
Remarks
sp_CancelQuery terminates the execution of a query by another user. To terminate a query, the query must be being actively processed on a data dictionary connection. Query termination requires an administrative connection to the same data dictionary as the other user is connected to. Queries on non-data dictionary connections cannot be cancelled.
See Also