15.10 - Example: Methods That Return a TD_ANYTYPE or INTEGER Data Type - 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

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';