RemoveObjectList | Application Programming Reference | Teradata Vantage - 17.10 - RemoveObjectList - 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 a named object list and all of its entries.

Syntax

REPLACE PROCEDURE TDSTATS.RemoveObjectList (
  IN ObjectListName VARCHAR(128) CHARACTER SET UNICODE, 
  IN ObjectListId BIGINT,
  OUT NumRemoved INTEGER
)
  ...
;

Syntax Elements

ObjectListName
Name of the existing object list. This list may contain both databases and fully qualified tables.
This input parameter cannot be NULL.
ObjectListId
ID of the existing object list to remove.
This input parameter cannot be NULL.
NumRemoved
Number of the database and table entries that were in the removed list.

Usage Notes

You can view object list data in the TDSTATS.ObjectList and TDSTATS.ObjectListEntry tables. The names of the object lists are stored in the TDSTATS.ObjectList.ListName column.

Example: Using RemoveObjectList

The following example shows how to remove the newly created object list named FinCashList and its entries.

CALL TDSTATS.CreateObjectList('FinCashList',ObjectListId);
CALL TDSTATS.AddObjectListEntry('FinCashList',NULL,'Fin%',NULL);
CALL TDSTATS.AddObjectListEntry('FinCashList',NULL,'Account%','Cash%');
CALL TDSTATS.RemoveObjectList('FinCashList',NULL,NumRemoved);