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

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)

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 ?