RemoveQueryListEntry | Application Programming Reference | Teradata Vantage - 17.10 - RemoveQueryListEntry - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1090-171K
Language
English (United States)

Removes an individual query from a query list.

Syntax

REPLACE PROCEDURE TDSTATS.RemoveQueryListEntr (
  IN QueryListName VARCHAR(128) CHARACTER SET UNICODE,
  IN QueryID       DECIMAL(18,0)
)
  ...
;

Syntax Elements

QueryListName
Name of the existing query list containing the query to be removed.
This input parameter cannot be NULL.
QueryID
DBQL-assigned ID of the query.
This input parameter cannot be NULL.

Usage Notes

When you specify an individual query to remove, it must have already been added to an existing query list by a call to the AddQueryListEntry external stored procedure. All other queries in the query list will remain intact.

You can view the query list data in the TDSTATS.QueryList and TDSTATS.QueryListEntry tables and the names of the query lists in the TDSTATS.QueryList.ListName column.

Example: Using RemoveQueryListEntry

The following example shows how to remove an individual query (for example, query 8675309) from the query list named MySlowQueries.

CALL TDSTATS.RemoveQueryListEntry('MySlowQueries',8675309);

Related Information

For more information about the AddQueryListEntry external stored procedure, see AddQueryListEntry.