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