Scalar Function Parameter List | External Routine Programming | Teradata Vantage - 17.10 - Scalar Function Parameter List - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

The parameter list must correspond to the parameter style in the CREATE FUNCTION statement for the UDF.

Use parameter style SQL to allow a UDF to pass nulls for the result or for input arguments; otherwise, use parameter style TD_GENERAL.

When you use parameter style SQL, you must define indicator parameters for the result and for each parameter.