16.20 - name IN TABLE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

Correlation name of an input table to use during function processing. See Example: Function Mapping Definition with IN TABLE Options.

You can also specify a substitute name to enable another name to be used during function processing. In the example below, the table ConversionEvents is used instead of the table conversion for function processing:
ConversionEvents(conversion) IN TABLE

See Example: Function Mapping Definition with IN TABLE Clause Substitution.

You cannot specify IN TABLE clause variables as parameters or values in other function parameters.

You cannot specify the same variable name in multiple IN TABLE clauses.

You cannot specify ANY as a value if you use the ANY IN TABLE clause.

An IN TABLE clause cannot contain any of the following:
  • Concatenated variable expression
  • Scalar subquery expression (SSQ)
  • Default value
  • Nested values