Deletes a query list previously created by AddQueryList along with all of its entries.
Syntax
REPLACE PROCEDURE TDSTATS.RemoveQueryList ( IN QueryListName VARCHAR(128) CHARACTER SET UNICODE, OUT NumRemoved INTEGER ) ... ;
Syntax Elements
- QueryListName
- Name of the existing query list created by a call to AddQueryList. For more information, see AddQueryList.
- NumRemoved
- Number of query entries removed along with the specified list.
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.
Example: Using RemoveQueryList
The following example shows how to remove the query list named MySlowQueries.
CALL TDSTATS.RemoveQueryList('MySlowQueries',NumRemoved);
Related Information
| For more information on .... | See ... |
|---|---|
| previous created query lists | AddQueryList. |
| removing an individual query entry from a list | RemoveQueryListEntry. |