Scalar UDF | SQL Operators & User-Defined Functions | Teradata Vantage - 17.10 - Scalar UDF - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Operators and User-Defined Functions

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

Takes input arguments and returns a single value result.

ANSI Compliance

This statement is ANSI SQL:2011 compliant, but includes non-ANSI Teradata extensions.

The requirement that parentheses appear when the argument list is empty is a Teradata extension to preserve compatibility with existing applications.

The RETURNS data_type or RETURNS STYLE clauses are Teradata extensions to the ANSI SQL standard.

Required Privileges

You must have EXECUTE FUNCTION privileges on the function or on the database containing the function.

To invoke a scalar UDF that takes a UDT argument or returns a UDT, you must have the UDTUSAGE privilege on the SYSUDTLIB database or on the specified UDT.


udf_name ( [ argument [,...] ] )

For UDFs that are defined with parameters of TD_ANYTYPE data type:

( udf_name
  { () RETURNS { data_type | STYLE column_expr } |

    ( argument [,...] )
      [ RETURNS { data_type | STYLE column_expr } ]

Syntax Elements

The name of the scalar UDF.
A valid SQL expression.
The desired return type of the TD_ANYTYPE result parameter.
A table or a view column reference that determines the return type of the TD_ANYTYPE result parameter.