16.20 - 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
April 2020
Content Type
Programming Reference
Publication ID
English (United States)
Teradata Database provides a parameter data type called TD_ANYTYPE that can accept any system-defined data type or UDT. 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
  • Input parameters and return value in UDMs

You cannot use TD_ANYTYPE as the return type in table functions.

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