meta_MacroParameters

Teradata Meta Data Services User Guide

Product

Teradata Meta Data Services

Release Number

15.00

Language

English (United States)

Last Update

2018-09-27

Product Category

Teradata Tools and Utilities

Returns the parameters defined for the current macros in systems being tracked by MDS. Corresponds to the relationship MacroHasParameters.

Table 109: Columns, Data Types, and Values of the meta_MacroParameters View
Column	Data Type	Values
SystemName	VARCHAR(256)
DatabaseName	VARCHAR(128)
MacroName	VARCHAR(128)
ParameterName	VARCHAR(128)
ParameterPositionID	SMALLINT
ParameterDataType	CHAR(2)
ParameterDataTypeA	VARCHAR(29)	1-dimensional Array ANSI Time BLOB VARBYTE CLOB Decimal Day Day to Minute Date Tag Hour Hour To Second Byte Integer BIGINT Minute Minute To Second PERIOD(TIME) PERIOD(TIMESTAMP) Second TD_VALIST Timestamp Unicode Fixed Character XML Year to Month	n-dimensional Array Binary Fixed Binary String Character Fixed VARCHAR Date Day To Hour Day to Second Real/Float Hour To Minute Integer Short Integer JSON Month NUMBER PERIOD(DATE) PERIOD(TIME)w/TimeZone PERIOD(TIMESTAMP)w/TimeZone Timestamp w/ TimeZone ANSI Timestamp w/ TimeZone User Defined Type Year
ParameterLength	INTEGER
CharType	SMALLINT
CharacterSet	VARCHAR(8)	Graphic Latin Unicode	Kanji1 ShiftJIS Other
DefaultValue	VARCHAR(1024)
ParameterTitle	VARCHAR(256)
ParameterComment	VARCHAR(255)
MacroLoid	INTEGER
ParameterLoid	INTEGER