specific_method_clause - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™

This clause is mandatory for overloaded method_names, but is otherwise optional and can only be specified once per method definition.

SYSUDTLIB
Unlike method_name, specific_method_name must be unique within SYSUDTLIB.
specific_method_name
Specific name for the method.
For information about naming database objects, see Teradata Vantage™ - SQL Fundamentals, B035-1141.
This name is stored in DBC.TVM as the name of the method database object.
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. Otherwise, Vantage returns an error to the requestor. Instead, use a multibyte session character set.