RemoveQueryList | Application Programming Reference | Teradata Vantage - 17.05 - RemoveQueryList - Teradata Database

Teradata Vantageā„¢ - Application Programming Reference

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1090-170K

Deletes a query list previously created by AddQueryList along with all of its entries.

Definition

REPLACE PROCEDURE TDSTATS.RemoveQueryList
 (IN QueryListName VARCHAR(128) CHARACTER SET UNICODE,
  OUT NumRemoved   INTEGER)
           .
           .
           .
;

Input Parameter

Parameter Description
QueryListName Name of the existing query list created by a call to AddQueryList. For more information, see AddQueryList.
This input parameter cannot be NULL.

Usage Notes

To remove only an individual query entry from a list, you must call the RemoveQueryListEntry external stored procedure.

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.

Output Parameter

Parameter Description
NumRemoved Number of query entries removed along with the specified list.

Example: Using RemoveQueryList

The following example shows how to remove the query list named MySlowQueries.

CALL TDSTATS.RemoveQueryList('MySlowQueries',NumRemoved);

Related Topics

For more information on .... See ...
previous created query lists AddQueryList.
removing an individual query entry from a list RemoveQueryListEntry.