16.20 - Table Function Parameter List - 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)

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.