Navigation:  Advantage SQL > System Procedures > Procedures >

sp_CancelQuery

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

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

sp_GetSQLStatements