Table functions are a type of User-Defined Function (UDF) in which a table is returned rather than a scalar or aggregate value. These functions are only available when connected to a Teradata database. They may be user-defined or system-supplied. Because they return a table rather than a value, Table functions may only appear in the FROM clause of a SQL statement. In fact, only one Table function may appear in a FROM clause, and not in a FROM clause that contains a JOIN condition.
More specifically, the SQL elements in this category may only be utilized in Function Tables. Refer to Variable Creation - INPUT - Variables - Function Tables for a description of how Function Tables may be defined and how the columns in a Function Table may be selected into variables, dimensions, expert clauses and search expressions. For information about the specific Table Functions listed in this section, refer to the appropriate Teradata Reference Manual. Most are found in SQL Functions, Operators, Expressions and Predicates, B035-1145.
Double-click on Table Functions to view the available functions. You can select either the generic Table Function (any) option, or a specific function, in which case either a dialog specific to the selected function is displayed, or the same generic dialog is displayed with the database and specific function name preselected.