15.10 - Example: HELP METHOD with Sample Output - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Last Update
2018-06-05
Content Type
Programming Reference
Publication ID
B035-1144-151K
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 ?