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™
The method to be altered.
INSTANCE
that the method named as method_name is an instance method.
This is the default.
CONSTRUCTOR
The method named as method_name is a constructor method.
SYSUDTLIB.method_name
The name (not the specific method name) for the method to be altered.
There must already be a method associated with the specified UDT name that has the same signature.
The specification of SYSUDTLIB is optional.
data_type
An optional data type specification for the parameters passed to method_name.
If you do not specify a data type list, then the specified method must be the only one with that name in the SYSUDTLIB database.