15.10 - parameter_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
December 2015
English (United States)
Last Update

A set of parameter names for the method.

The parameter list is a parenthetical comma-separated list of data types, including UDTs, and optional parameter names and locators for the variables to be passed to the method.

Parameter names must be unique within a method definition.

You cannot use the keyword SELF to name method parameters.

The maximum number of parameters a method accepts is 128.

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

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

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

If you do not specify parameter names, the system assigns unique names to them in the form P1, P2, …, Pn. These names are used in the COMMENT statement (see COMMENT (Comment Placing Form)), displayed in the report produced by the HELP METHOD statement in the PARAMETER NAME column (see HELP METHOD), and appear in the text of error messages.

If a parameter in the parameter_name list has a UDT type, the UDT_name entry is the name of that UDT.
data type
Whether you specify a list of parameter names or not, you must specify a set of data types for the parameters specified.
  • If a parameter in the parameter_name list has a predefined data type, the data_type entry is that data type.
  • If the type specified as data_type is a character type, the server_character_set entry is its server character set.
The data type associated with each parameter is the type of the parameter or returned value. All Teradata Database data types are valid. Distinct and structured UDTs are valid for scalar UDFs only.
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.
CHARACTER SET server_character_set
Character data can also specify a CHARACTER SET clause.
You cannot specify a character server data set of KANJI1. Otherwise, the system returns an error to the requestor.