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

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

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.