Create and Maintain Query Lists | Application Programming Reference | Vantage - Creating and Maintaining Query Lists - Advanced SQL Engine - Teradata Database

Application Programming Reference

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
cpn1571792172880.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1090
lifecycle
previous
Product Category
Teradata Vantageā„¢

A query list allows you to identify and analyze a set of queries based on arbitrary user-defined criteria.

Query List open APIs use one or more DBQL query IDs that are associated with a named identifier. This identifier can be passed to the Analyzer open API, AnalyzeStatsUsage, as an input argument. For more information about this open API, see AnalyzeStatsUsage.

You can use these open APIs to create and maintain query lists.

Functionality

If you want to ... Use the following SQL interface ...
create a new query list AddQueryList.
add a query to a named list AddQueryListEntry.
drop a list and all queries within it RemoveQueryList.
drop an individual query from a list RemoveQueryListEntry.