CREATE FUNCTION GetConf() RETURNS TABLE
(
NAME  VARCHAR(50),
VALUE VARCHAR(80)
)
BEGIN ATOMIC
RETURN
SELECT NAME, VALUE FROM OCONF WHERE NAME<>x'536F66742056657273696F6E'
UNION
select NAME, VALUE FROM (SELECT x'536F66742056657273696F6E' AS NAME, x'322E342E333336392E37' AS VALUE FROM WORK_TYPE fetch first row only) AS A;
END