Table Function Parameter List | External Routine Programming | Teradata Vantage - 17.10 - Table Function Parameter List - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

The parameter list of a table function is similar to the parameter list of a scalar function. The main difference is that the table function parameter list can include multiple result parameters because a table function returns a row result instead of just one value.

A table function can have:
  • 128 input parameters
  • as many result parameters as defined by the RETURNS TABLE clause of the CREATE FUNCTION or REPLACE FUNCTION statement for the table function.

    The number of result parameters is limited by the maximum number of columns that can be defined for a regular table.

The data type of a result parameter in a table function cannot be TD_ANYTYPE.