CREATE FUNCTION FUNC_1()
RETURNS TABLE (
VALUE_1 INTEGER,
VALUE_2 INTEGER,
VALUE_3 DECIMAL(15,2)
)
LANGUAGE SQL

BEGIN

DECLARE GLOBAL TEMPORARY TABLE SESSION.TABLE_TMP
(VALUE_1 INTEGER,VALUE_2 INTEGER,VALUE_3 DECIMAL(15,2));

FOR V1 AS CUR CURSOR FOR
select *
from TABLE_1
DO
	insert into SESSION.TABLE_TMP (VALUE_1,VALUE_2,VALUE_3)
	select VALUE_1,VALUE_2,VALUE_3
	from table(FUNC_2(V1.VALUE_1)) as T;
END FOR;

RETURN select VALUE_1,VALUE_2,VALUE_3
from SESSION.TABLE_TMP;
	
END;