16.20 - method_name - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

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 Teradata Vantage™ 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 Teradata Vantage™ SQL External Routine Programming , B035-1147 .

For information about instance methods and constructor methods, see the CREATE METHOD topic “Method Types” in Teradata Vantage™ 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.