15.10 - method_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

The 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, or method, even if the new object name contains only single-byte characters. Instead, use a multibyte session character set. Otherwise, Teradata Database returns an error to the requestor.

The name for a method object must conform to object naming rules. For object naming rules, see SQL Fundamentals, B035-1141.

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 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.

SQL supports function name overloading within the same method class, so method_name does not have to be unique within its class.

Parameter data types and number of parameters are used to distinguish among different methods within the same class that have the same method_name.

For more information about function overloading, see SQL External Routine Programming, B035-1147.

For information about instance methods and constructor methods, see the CREATE METHOD topic “Method Types” in SQL Data Definition Language - Detailed Topics, B035-1184.

INSTANCE
The object is an instance method.
INSTANCE is the default.
CONSTRUCTOR
The object is a constructor method.