Rules for Order Mapping UDFs | CREATE ORDERING | Teradata Vantage - 17.10 - Rules for Order Mapping UDFs - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)
If you specify a UDF as the MAP routine for an ordering, it must obey the following rules:
  • It must have one and only one parameter.
  • The data type of the single parameter you specify must be the same as that of the UDT specified as UDT_name.
  • The result data type must be a predefined data type.
    Its predefined data type is valid except the following:
    • BLOB
    • CLOB
  • It must be declared to be DETERMINISTIC.
  • The name you specify for it in the ordering definition must be the name of a UDF contained within the SYSUDTLIB database.

See CREATE FUNCTION and REPLACE FUNCTION (External Form) for details about UDF parameters, result data types, and the DETERMINISTIC option.