HELP METHOD Examples | Teradata Database - Example: HELP METHOD with Sample Output - Teradata Database

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;

Result:

          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 ?