17.10 - Parameter List and Return Value - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

The list of parameters for a method that implements a UDF is very specific. It includes the input parameters that Vantage passes when the UDF appears in an SQL statement.

A UDF can have 0 to 128 input parameters.

A Java UDF cannot have an ARRAY type parameter where the base type is a nested structured UDT.