17.10 - SQL Definitions for the Ordering Method - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

The following CREATE METHOD statement installs the ordering method in the database:

CREATE METHOD circle_t_Ordering()
   RETURNS FLOAT
   FOR circle_t
   EXTERNAL NAME 'CS!c_order!udmsrc/c_order.c!F!circle_t_Ordering';

The following statement registers the circle_t_Ordering UDM as an ordering routine for the circle_t UDT:

CREATE ORDERING FOR circle_t
   ORDER FULL BY MAP WITH SPECIFIC METHOD circle_t_Ordering;