capabilities.work

Cancel a Running Query

A 4-step recipe with Teradata. We can help you get access.

Recipe · 4 steps

Cancel a Running Query

with Teradata

Submit a query and cancel it if it is still running, otherwise end.

  1. Create a query session against the requested system.
  2. Submit the SQL statement and capture the query identifier.
  3. Retrieve the query status and branch on whether it is still running.
  4. Cancel the still-running query to free Vantage resources.
What you'll need to have ready
  • system: Target Vantage system name.
  • username: Database username used to open the session.
  • database: Default database for the session.
  • query: SQL statement to execute.
For your developer

Arazzo workflow teradata:cancel-running-query, 4 operations: createSession → executeQuery → getQueryStatus → cancelQuery. Specs on APIs.io.

More recipes with Teradata

Auto-Install Node SoftwareBuild a Data FabricImport and Verify a Remote SystemSubmit Query and Poll for ResultsProvision a Cross-System LinkRegister a System in a New Data CenterReview QueryGrid Environment HealthRun a Connectivity DiagnosticRun Query in a SessionSession Lifecycle