CREATE FUNCTION REPLACE(CHAR( 1024 ), CHAR( 256 ), CHAR( 256 ))
RETURNS CHAR( 1024 )
LANGUAGE C
EXTERNAL NAME 'REPLICA/REPLACE(REPLACE)'
DETERMINISTIC
NO EXTERNAL ACTION
PARAMETER STYLE SQL
ALLOW PARALLEL;

CREATE FUNCTION JDATE(INT,INT,INT)
RETURNS INT
LANGUAGE C
EXTERNAL NAME 'DETRG/UDFS(JDATE)'
DETERMINISTIC
NO SQL
NO EXTERNAL ACTION
PARAMETER STYLE SQL
ALLOW PARALLEL;

CREATE FUNCTION DMONTH(INT)
RETURNS INT
LANGUAGE C
EXTERNAL NAME 'DETRG/UDFS(DMONTH)'
DETERMINISTIC
NO SQL
NO EXTERNAL ACTION
PARAMETER STYLE SQL
ALLOW PARALLEL;

CREATE FUNCTION SUPERCAT(CHAR( 60 ),CHAR( 60 ))
RETURNS CHAR( 60 )
LANGUAGE C
EXTERNAL NAME 'DETRG/UDFS(SUPERCAT)'
DETERMINISTIC
NO EXTERNAL ACTION
PARAMETER STYLE SQL
ALLOW PARALLEL;