HELP PROCEDURE Examples | Teradata Vantage - 17.05 - Example: Reporting UDT Parameters - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

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

The following example shows a possible report returned by HELP PROCEDURE when the data type of a parameter in the specified procedure is a UDT.

     HELP PROCEDURE udtblobset;
          Parameter Name b
                     Type UT
                  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 CRPV_BLOB

If the procedure had been defined with an input parameter with the VARIANT_TYPE data type, then the UDT Name in the output would have been reported as VARIANT_TYPE.