16.20 - parameter_name - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
March 2019
English (United States)
Last Update

A parenthetical comma-separated list of data types, including UDTs, and parameter names for the variables to be passed to the SQL function. The data types are required to differentiate between functions with the same name.

For information about naming database objects, see Teradata Vantage™ SQL Fundamentals, B035-1141.

The maximum number of parameters an SQL UDF accepts is 128.

You must specify opening and closing parentheses even if no parameters are to be passed to the function.

Parameter names must be unique within an SQL UDF definition.

If you specify one parameter name, then you must specify names for all the parameters passed to the function.

data type
The data type associated with each parameter is the type of the parameter or returned value. All Teradata Database data types except VARIANT_TYPE and TD_ANYTYPE are valid. Character data can also specify a CHARACTER SET clause.
Although you can specify the CHARACTER SET for a parameter, the CHARACTER SET of the caller of the SQL UDF argument is what Teradata Database uses for SQL UDF processing.
You cannot specify a character server data set of KANJI1. Otherwise, Teradata Database returns an error to the requestor.
For data types that take a length or size specification, like BYTE, CHARACTER, DECIMAL, VARCHAR, and so on, the size of the parameter indicates the largest number of bytes that can be passed.