15.10 - RemoveQueryList - Teradata Database

Teradata Database Application Programming Reference

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
featnum
B035-1090-151K

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

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

Parameter

Description

QueryListName

Name of the existing query list created by a call to AddQueryList. For more information, see “AddQueryList” on page 609.

Note: This input parameter cannot be NULL.

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.

 

Parameter

Description

NumRemoved

Number of query entries removed along with the specified list.

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

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

For more information on ....

See ...

previous created query lists

“AddQueryList” on page 609.

removing an individual query entry from a list

“RemoveQueryListEntry” on page 615.