17.00 - Example: HELP TYPE for an ARRAY with the ATTRIBUTE Option - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
Last Update
2021-01-23

This example extends the previous example to specify the ATTRIBUTE option for the HELP TYPE request. The ARRAY type used for the example is arrayvec, which was defined in Example: HELP TYPE for a One-Dimensional ARRAY.

The HELP TYPE request for the ARRAY type arrayvec specified with the ATTRIBUTE option returns the following report.

     HELP TYPE arrayvec ATTRIBUTE;
          Attribute Name arrayvec
                     Type I
               Max Length              4
     Decimal Total Digits     ?
Decimal Fractional Digits     ?
                Range Low                 ?
               Range High                 ?
                Char Type  1
                 UDT Name ?