CREATE TYPE Examples | Teradata Vantage - CREATE TYPE Examples (Distinct Form) - Advanced SQL Engine - Teradata Database

Example: Creating a Distinct UDT for Euro Conversion

The following example creates a distinct UDT named euro based on the source data type DECIMAL(8,2):

    CREATE TYPE euro 
    AS DECIMAL(8, 2) 
    FINAL
    METHOD toUS()
    RETURNS us_dollar CAST FROM DECIMAL(8,2)
    LANGUAGE C
    DETERMINISTIC
    NO SQL
    RETURNS NULL ON NULL INPUT;
    …

Example: Creating a Distinct UDT for Dollar Conversion

The following example creates a distinct UDT named us_dollar based on the source data type DECIMAL(8,2):

    CREATE TYPE SYSUDTLIB.us_dollar 
    AS DECIMAL(8, 2) 
    FINAL
    METHOD toEuro()
    RETURNS euro CAST FROM DECIMAL(8,2)
    LANGUAGE C
    DETERMINISTIC
    NO SQL
    RETURNS NULL ON NULL INPUT;