HELP METHOD Examples | Teradata Vantage - Example: HELP METHOD with Sample Output - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
ft:locale
en-US
ft:lastEdition
2021-07-27
dita:mapPath
spp1591731285373.ditamap
dita:ditavalPath
spp1591731285373.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

The following example reports the parameter list of the method named int_ordering that is associated with the UDT named udt_int.

     HELP METHOD int_ordering FOR udt_int;           Parameter Name SELF Type UT Comment ? Nullable Y Format ? Max Length 0 Decimal Total Digits ? Decimal Fractional Digits ? Table/View? M Char Type ? Parameter Type I UDT Name UDTINT Parameter Name RETURN0 Type I Comment ? Nullable Y Format -(10)9 Max Length 4 Decimal Total Digits ? Decimal Fractional Digits ? Table/View? M Char Type ? Parameter Type O UDT Name ?