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

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™
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.