Constant Mode Table Function Body | SQL External Routine Programming | Vantage - Constant Mode Table Function Body - 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
ft:locale
en-US
ft:lastEdition
2025-03-30
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
qnu1472247494689
lifecycle
latest
Product Category
Teradata Vantageā„¢

This section provides guidelines on how to implement the body of a table function that the SELECT statement invokes with constant expression input arguments.

For example, the following statement invokes table_function_1 with a constant argument:

SELECT *
FROM TABLE (table_function_1('STRING_CONSTANT'))
AS table_1;
Although this section discusses how to implement a table function that only handles constant expression input arguments, you can design a table function that can handle constant and variable input arguments. For details on how to implement a variable mode table function, see Variable Mode Table Function Body.