Hi,

I have very little knowledge about creating Procedures/functions in
DB2.

When i tried to create the test function like

CREATE FUNCTION GET_TEST
(P_TEST_ID INTEGER,
P_SEL_OR_SORT INTEGER,
P_TEST VARCHAR(2)
)
RETURNS VARCHAR(1000)
SPECIFIC GET_RULE
LANGUAGE SQL
NOT DETERMINISTIC
READS SQL DATA
STATIC DISPATCH
CALLED ON NULL INPUT
EXTERNAL ACTION
INHERIT SPECIAL REGISTERS
BEGIN ATOMIC
DECLARE v_TEST VARCHAR(4000);
DECLARE v_TEST_Select VARCHAR(4000);
DECLARE v_TEST_Sort VARCHAR(1000);
DECLARE GLOBAL TEMPORARY TABLE TEMP_TEST
(id INTEGER
)
ON COMMIT PRESERVE ROWS;

SET v_TEST_Select = NULL;
SET v_TEST_Sort = NULL;
RETURN(v_TEST);
END;


It give an error SQL 0104N "An unexpected token "Table" was found
following "..are Global Temporary".

What is the problem in that?