Example: Methods That Return a TD_ANYTYPE or INTEGER Data Type - Advanced SQL Engine - Teradata Database

Method td_anytyp_x1 takes a TD_ANYTYPE parameter and returns an INTEGER.

     CREATE METHOD td_anytyp_x1 (p1 TD_ANYTYPE)
     RETURNS INTEGER
     FOR myUDT
     EXTERNAL NAME 'CS!td_anytyp_x1!td_anytyp_x1.c!F!td_anytyp_x1';

Method td_anytpe_x2 takes a TD_ANYTYPE parameter and returns a TD_ANYTYPE.

     CREATE METHOD td_anytpe_x2(p1 TD_ANYTYPE)
     RETURNS TD_ANYTYPE
     FOR myUDT
     EXTERNAL NAME 'CS!td_anytpe_x2!td_anytpe_x2.c!F!td_anytpe_x2';