15.10 - CreateObjectList - Teradata Database

Teradata Database Application Programming Reference

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

Creates a new object list with a user specified name.

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

Parameter

Description

ObjectListName

Name for the newly created object list.

Note: The name must be unique among all object lists stored in the TDSTATS database.

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” on page 604.

 

Parameter

Description

ObjectListId

ID of the created object list.

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