16.20 - Scalar Function Parameter List - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
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.