15.00 - Null Call Clause - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Release Number
Content Type
Programming Reference
Publication ID
English (United States)

Null Call Clause

You can pass a null as an input argument to a table function or return a null in a result row of a table function only when the data type of the corresponding parameter to its Java method is object‑mapped (see “Data Type Mapping Between SQL and Java” on page 433).

If the data type of the corresponding parameter to the Java method of the table function is defined as simple‑mapped, then attempts to evaluate a null at runtime fail and return an error to the requestor. This is because simple‑mapped data types cannot represent nulls.

See “Null Call Clause” on page 272 for general information about the Null Call clause. Note that the only form of null call supported by table functions is CALLED ON NULL INPUT.