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

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;