The following CREATE FUNCTION request specifies a CHAR2HEXINT function in its RETURN statement.
CREATE FUNCTION test.myudf (a CHARACTER(100)) RETURNS CHARACTER(400) LANGUAGE SQL DETERMINISTIC CONTAINS SQL SPECIFIC test.myudf CALLED ON NULL INPUT SQL SECURITY DEFINER COLLATION INVOKER INLINE TYPE 1 RETURN CHAR2HEXINT(a);