Macro Attributes | HELP MACRO | VantageCloud Lake - Macro Attributes - Teradata Vantage

Teradata® VantageCloud Lake
Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The columns or parameters are listed in the order in which they were defined.

The attributes are returned as shown in the following table.

Attribute Data Type Nullable? Description
Parameter Name VARCHAR(30) No The name of a parameter in the macro.

The system returns the set of attributes shown in this attribute table for each column or parameter.

The following characteristics also apply:
  • Host Data Characteristics:
    • Interpret as the equivalent of CF, or CHARACTER(n) data type.
    • When DATEFORM=ANSIDATE, this column must be described externally as CHARACTER(10).
  • Format Characteristics:
    • With an explicit format, DATE.
    • With an implicit format created in ANSIDATE mode, 'YYYY/MM/DD'.
Data Type CHARACTER(2) Yes The data type for the Parameter Name.

See Data Type Codes for a list of the data type codes and their meanings

The server character data types LATIN, UNICODE, GRAPHIC, KANJISJIS, and KANJI1 are distinguished with respect to CF and CV by their respective value for the Character Type column.
Comment VARCHAR (255) Yes The contents of the optional comment field for the macro, if a comment was created.
Nullable CHARACTER Yes Indicates whether the macro parameter specified in the Parameter Name field is nullable.
  • N specifies nullable.
  • Y specifies not nullable.
Format CHARACTER(30) Yes Display format for the data type.

For data type display formats, see Default Formats.
Title VARCHAR (60) Yes The title for Parameter Name, if used.
Max Length INTEGER Yes Return the length in bytes for the macro parameters specified in Parameter Name.

MaxLength is the length of the external CharFix representation of the parameter, defined as CHARACTER(MaxLength) in USING clauses and any other place this must be specified.

MaxLength is typically expressed as internal size, but external size is more appropriate for these data types.

For the DATE type MaxLength is 4, representing the internal storage size.

For CHARACTER data, Max Length is the length of the parameter declaration in bytes.

For HELP MACRO, requests return the length of the macro parameter.

See the external representation for each individual DateTime and Interval type in DateTime and Interval Data Types to determine the MaxLength values.

You can use the StatementInfo parcel to return the description of items within the Data Field of the corresponding indicator mode Record parcels.

For example, the FastLoad .TABLE command can run in Indicator Mode to get the additional information of data type and length of all attributes. That information can then be used to fetch the data correctly in any database release.
Decimal Total Digits SMALLINT Yes Indicates the total number of digits for decimal data.

For INTERVAL types, returns a value from 1–4 representing the number of digits in the leading field of the interval (number of non-fractional digits for INTERVAL SECOND).

This column is null for other TIME and TIMESTAMP data types.
Decimal Fractional Digits SMALLINT Yes Indicates the decimal precision of the parameter in Parameter Name.

If the Type is TIME or TIMESTAMP types, or any INTERVAL type with a SECOND field, this column returns a value of 0–6, indicating the fractional precision of seconds.

For INTERVAL types without a SECOND field, the column returns null.

Null for other data types.
Range Low FLOAT Yes Always null. BETWEEN clause is included in column constraint.
Range High FLOAT Yes Always null. BETWEEN clause is included in column constraint.
Uppercase CHARACTER Yes Applies if the type is CHARACTER or VARCHAR.
  • B specifies that column attributes for both UPPERCASE and CASESPECIFIC are defined.
  • C specifies that the column attributes for CASESPECIFIC is defined.
  • N specifies that column attributes for neither UPPERCASE nor CASESPECIFIC are defined.
  • U specifies that the column attributes for UPPERCASE is defined.
Table/View? CHARACTER No The object type. See TVM Kind Codes.

HELP MACRO requests return a code of M for macro.
Default Value VARCHAR (255) Yes Returns the default value (as text) for the parameter.

The value is null if there is no default value.
Character Type SMALLINT Yes Returns a code identifying the character data type for the parameter shown in Parameter Name.
  • 1 specifies LATIN server character data type columns.
  • 2 specifies UNICODE server character data type columns.
  • 3 specifies KANJISJIS server character data type columns.
  • 4 specifies GRAPHIC server character data type columns.
  • 5 specifies KANJI1 server character data type columns.

If the data type of the column is not character, returns null.
IDCol Type CHARACTER(2) Yes Returns a code for the type of identity column.
  • GA specifies Generated Always.
  • GD specifies Generated by Default.
Temporal Column CHARACTER(2) Yes Whether a column is temporal or part of a Temporal Relationship constraint:
Value Meaning
Null Column is nontemporal,
R Column is part of temporal relationship constraint.
T Column has TRANSACTIONTIME column.
V Column has VALIDTIME column.
Current ValidTime Unique? CHARACTER(2) Yes Reports whether a column is a UNIQUE Current VALIDTIME column or not.
Sequenced ValidTime Unique? CHARACTER(2) Yes Reports whether a column is a UNIQUE Sequenced VALIDTIME column or not.
NonSequenced ValidTime Unique? CHARACTER(2) Yes Reports whether a column is a UNIQUE Nonsequenced VALIDTIME column or not.
Current TransactionTime Unique? CHARACTER(2) Yes Reports whether a column is a UNIQUE Current TRANSACTIONTIME column or not.
Parameter Dictionary Name VARCHAR(128) No The attributes shown in this section are derived from and supersede the corresponding older Parameter Name and Title attributes, while providing additional functionality.

These attributes are returned for each parameter in the specified method.

The older attributes are retained for compatibility with legacy applications.

For details on the new attributes, see the topics beginning with Object Name and Title Data in HELP Reports.
Parameter SQL Name VARCHAR(644) No
Parameter Name Uescape VARCHAR(1) Yes
Dictionary Title VARCHAR(256) Yes
SQL Title VARCHAR(1256) Yes
Title Uescape VARCHAR(1) Yes