16.20 - Restrictions on Calling Table Functions - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

You can only call a table function in the FROM clause of an SQL SELECT request (see Teradata Vantage™ SQL Data Manipulation Language , B035-1146 ), which includes calling table functions in the FROM clause of a subquery. Calling a table function from any other clause within a query causes the system to abort the request and returns an error to the requestor.