Defining Functions that Use the TD_ANYTYPE Type | Java UDFs | Teradata Vantage - 17.10 - Defining Functions that Use the TD_ANYTYPE Type - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
Teradata 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.