CreateObjectList | Application Programming Reference | Teradata Vantage - 17.05 - CreateObjectList - 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

Creates a new object list with a user-specified name.

Definition

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

Input Parameter

Parameter Description
ObjectListName Name for the newly created object list.
The name must be unique among all object lists stored in the TDSTATS database.

Usage Notes

After a new object list is created, you can call AddObjectListEntry to add objects to a list.

To add database or tables to the list, see AddObjectListEntry.

Output Parameter

Parameter Description
ObjectListId ID of the created object list.

Example: Using CreateObjectList

The following example shows how to create a list consisting of all finance databases and cash tables within account databases.

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