15.10 - Example: Reporting ARRAY Parameters for a Procedure - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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