Defining C/C++ Functions that Use the TD_ANYTYPE Type | Teradata Vantage - Defining C/C++ Functions that Use the TD_ANYTYPE Type - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
Product Category
Teradata Vantageā„¢
Teradata 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.