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

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

Syntax

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

Syntax Elements

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

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.

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%');