Cancels a query being processed by the Advantage Query Engine.
sp_CancelQuery( Query Number, Integer );
Query Number (I)
Number of the query to cancel. The query number is returned by sp_GetSQLStatements.
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.