Calling name for the method.
If the UDF library for your database contains any objects with multibyte characters in their name, you cannot use a single-byte session character set to create a new UDF, UDT, method, even if the new object name contains only single-byte characters. Instead, use a multibyte session character set. For related information about the following topics, see the external forms of CREATE FUNCTION and REPLACE FUNCTION in
Teradata Vantage™ - SQL Data Definition Language Detailed Topics
, B035-1184
:
- Function identifiers
- Function names
- Function calling arguments
- Function name overloading
- Parameter names and data types
- INSTANCE
- The object is an instance method.
- CONSTRUCTOR
- The object is a constructor method.
- SYSUDTLIB
- method_name must be unique within the SYSUDTLIB database. You cannot give a method the same name as an existing method or any other database object contained within the SYSUDTLIB database.
- method_name
- method_name must match the spelling and case of its C/C++ method name exactly if you do not specify a specific_method_name or external_method_name. This applies only to the definition of the method, not to its use.
- parameter_name
- The maximum number of parameters a method accepts is 128.
- data_type
- A parenthetical comma-separated list of data types and optional parameter names for the variables to be passed to the function.
- UDT_name
- If you specify a UDT, the current user of the method must have one of the following privilege sets:
- UDTMETHOD, UDTTYPE, or UDTUSAGE on the SYSUDTLIB database.
- UDTUSAGE on the specified UDT.
- AS LOCATOR
- BLOB and CLOB types must be represented by a locator. Vantage does not support in-memory LOB parameters. You must specify an AS LOCATOR phrase for each LOB parameter and return value. For a description of locators, see Teradata Vantage™ - SQL Data Manipulation Language, B035-1146.
- FOR [SYSUDTLIB.]UDT_name
- Name of the UDT to which this method applies.