17.05 - Example: Reporting ARRAY Parameters for a Procedure - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
Release Date
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

The following example shows a possible report returned by HELP PROCEDURE when the data type of a parameter in the specified procedure is an ARRAY. Suppose you create a one-dimensional ARRAY named structudt_ary.

          Parameter Name b
                     Type A1
                  Comment ?
                 Nullable Y
                   Format ?
                    Title ?
               Max Length ?
     Decimal Total Digits ?
Decimal Fractional Digits ?
                Range Low ?
               Range High ?
                UpperCase N
              Table/View? P
            Default Value ?
                Char Type ?
           Parameter Type O
               IdCol Type ?
                 UDT Name structudt_ary