15.10 - METHOD method_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Language
English (United States)
Last Update
2018-06-05
dita:mapPath
SQL_DDL_15_10.ditamap
dita:ditavalPath
ft:empty

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;