16.20 - Method Signature for Scalar UDFs - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
16.20
Release Date
April 2020
Content Type
Programming Reference
Publication ID
B035-1147-162K
Language
English (United States)
public class  class_name  {

   ...

   public static  result_type   method_name  (  type_1      input_param_1,
                                           ...,
                                           type_n      input_param_n)
   {
        ...
   }
}

where:

Return Type/Parameter … Specifies …
result_type a Java primitive or class corresponding to the SQL data type in the RETURNS clause of the corresponding CREATE FUNCTION statement.
type_n input_param_n the input parameters, where n is the number of parameters in the CREATE FUNCTION definition. If n = 0, no input parameters appear. The type is a Java primitive or class corresponding to the SQL data type of the input argument.

The maximum number of input parameters is 128.