16.20 - Defining Functions that Use the TD_ANYTYPE Type - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)
Teradata Database provides a parameter data type called TD_ANYTYPE that can accept any system-defined data type. You can specify TD_ANYTYPE as a data type for:
  • Input parameters in scalar, aggregate and table functions
  • Result parameters in scalar and aggregate functions
  • IN, INOUT, or OUT parameters in external stored procedures
You cannot use TD_ANYTYPE:
  • As the return type in table functions
  • As input parameters and return value in UDMs because you cannot write UDMs in Java
  • To represent UDT parameters because UDT parameters are not supported in Java routines

The parameter attributes and return type are determined at execution time based on the actual arguments passed to the routine.

The TD_ANYTYPE parameter is mapped to java.lang.Object in the Java routine. You must specify java.lang.Object as the Java parameter type corresponding to the TD_ANYTYPE parameter in the UDF.