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;