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

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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 ?