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

SQL Operators and User-Defined Functions

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2023-04-27
dita:mapPath
xwv1596137968859.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1210
lifecycle
previous
Product Category
Teradata Vantage™

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.

Syntax

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

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