Table Functions (Teradata Database) - Teradata Warehouse Miner

Teradata Warehouse Miner User Guide - Volume 2ADS Generation

Product
Teradata Warehouse Miner
Release Number
5.4.5
Published
February 2018
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
qhj1503087326201.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2301
Product Category
Software

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.

Variable Creation > Input > Variables: SQL Elements pane - Table Functions

Detailed information about the specific Table Functions below can be found in the appropriate Teradata Reference Manual. Most are described in SQL Functions, Operators, Expressions and Predicates, B035-1145.