15.10 - METHOD 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 name of the method.

The specified method must already be defined. If you specify the name of a method that has not yet been created, the system returns an error to the requestor.

data_type
Data type list that maps the UDT to a predefined data type value so it can be compared.

Example: Order Mapping for a UDT using a Method

The following order mapping definition for a UDT named circle uses the method named compare_circ(), which is also associated with the circle UDT.

    CREATE ORDERING FOR circle
    ORDER FULL BY MAP WITH METHOD compare_circ() FOR circle;