Categories:
System Functions (System Control)

SYSTEM$CANCEL_ALL_QUERIES

Cancels all active/running queries in the specified session.

See also:
SYSTEM$CANCEL_QUERY

Syntax

SYSTEM$CANCEL_ALL_QUERIES( <session_id> )

Arguments

session_id

Identifier for the session for which to cancel all queries. To obtain the ID for a session, log into the web interface as an account administrator (user with the ACCOUNTADMIN role) and go to:

Account Account tab » Sessions

Usage Notes

Examples

SELECT SYSTEM$CANCEL_ALL_QUERIES(1065153872298);

+------------------------------------------+
| SYSTEM$CANCEL_ALL_QUERIES(1065153872298) |
|------------------------------------------|
| 1 cancelled.                             |
+------------------------------------------+

For a more detailed, working example, see Canceling Statements.