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