method_clause - Advanced SQL Engine - Teradata Database

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.