16.20 - Constant Mode Table UDFs - 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)

This section provides guidelines on how to write a Java method for a table UDF that can handle an invocation from a SELECT statement that specifies constant expression input arguments.

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

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 UDFs.