Optional parameter names and locators for the variables to be passed to the function. A function that is used to compress or decompress a UDT column can have only one input parameter. The data type of the parameter can be any of the supported UDT data types.
For information about naming database objects, see Teradata Vantage™ - SQL Fundamentals, B035-1141.
You must specify opening and closing parentheses even if no parameters are to be passed to the function.
The maximum number of parameters a UDF accepts is 128.
The parameter data type of an algorithmic compression function used to compress a UDT column must match the RETURNS data type of its decompression function exactly. The type of an algorithmic compression function must also match the data type of the UDT column being compressed.
UDFs with a parameter type of UDT must reside in SYSUDTLIB rather than in SYSLIB.
- parameter name
- Parameter names must be unique within a UDF definition. If you specify one parameter name, then you must specify names for all the parameters passed to the function. You cannot use the keyword SELF to name UDF parameters. If you do not specify parameter names, Vantage assigns unique names to them in the form P1, P2, …, P n. These names are used in the COMMENT statement and displayed in the report produced by the HELP FUNCTION statement, and appear in the text of error messages. See COMMENT (Comment Placing Form) and HELP FUNCTION.
- data_type
- A parenthetical comma-separated list of data types, including UDTs. The data types are required to differentiate between overloaded functions with the same name.