Creating Object Lists | Application Programing Reference | Teradata Vantage - 17.05 - Creating Object Lists - 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

There are some situations where the desired scope for an Automate, Analyze, or Collect API call involves a list of objects that cannot be specified by the DatabaseName and TableName or ObjectName input parameters even with the use of wildcard characters (see AddQueryListEntry)

To solve this problem, you can create object lists that are capable of representing one or more database names or fully qualified table names where each name entry may optionally contain wildcard characters that are dynamically resolved at the time of API invocation.

You can use these open APIs to create a named object list that represents any arbitrary set of database or tables. The named object list can be passed to an Automate, Analyzer, or a Collect-related open API.

Functionality

If you want to ... Use the following SQL interface ...
create a new object list with a user specified name CreateObjectList.
add a database or table name to an existing named object list AddObjectListEntry.
remove a list and the object entries within it RemoveObjectList.
display the database and table objects contained within a specified object list SelectFromObjectList.