Example - Teradata Meta Data Services

Teradata Meta Data Services Programmer Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-28
Product Category
Teradata Tools and Utilities

Example

Dim colList As METACOMEXPORT21Lib.MetaInfoKeyList
Set colList = New MetaInfoKeyList
 
Dim col As MetaInfoKey
Set col = New MetaInfoKey
col.ObjectID = dbaim_h.PID_DATABASE_DATABASEID
colList.Add col
 
col.ObjectID = dbaim_h.PID_DATABASE_TYPE
colList.Add col

The "colList" object can now be used for the ColumnFilter parameter to retrieve objects from the DIM Column class. The result will be the usual number of objects, based on any other filters present, but with only the DatabaseID and DatabaseType unique properties present in each object's PropertyItem collection. Each object will also have all its common property values present, except for Description and ObjectGUID. To have either of these returned also, simply add their PIDs to the colList.