I'm migrating a Application from the Firebird Database to DB2 and I
need of some resource for migrating complex Stored Procedures that
transform values from tables in database and create a RecordSet return.

With SQL Functions in Java/C this is possible?

Stolze,

The real procedure I need build is more complex. Envolve many
computations and verifications. I sent an example of my necessity.

I see this sample in the ibm public help:

CREATE FUNCTION RANK(N INTEGER)
RETURNS TABLE(
 POSITION INTEGER,
 EMPNO CHAR(6),
 FIRSTNME CHAR(20),
 LASTNAME CHAR(20),
 SALARY DECIMAL(13,2)
)
LANGUAGE SQL
DISALLOW PARALLEL
MODIFIES SQL DATA
NOT FENCED
BEGIN
 DECLARE LAST_SALARY DEC(13,2) DEFAULT 0;
 DECLARE I INTEGER DEFAULT 1;
 DECLARE STMT VARCHAR(255);
 DECLARE TABLE_ALREADY_EXISTS CONDITION FOR '42710'; 1
 DECLARE CONTINUE HANDLER FOR TABLE_ALREADY_EXISTS 2
 DELETE FROM SESSION.RETURN_TBL;
 DECLARE GLOBAL TEMPORARY TABLE SESSION.RETURN_TBL ( 3
   POSITION INTEGER NOT NULL,
   EMPNO CHAR(6) NOT NULL,
   FIRSTNME CHAR(20) NOT NULL,
   LASTNAME CHAR(20) NOT NULL,
   SALARY DECIMAL(13,2) NOT NULL);

 FOR_LOOP: FOR EACH_ROW AS C1 CURSOR FOR
   SELECT EMPNO, FIRSTNME, LASTNAME, SALARY
   FROM SAMPLEDB01.EMPLOYEE ORDER BY SALARY DESC DO

   IF (I > N) AND (EACH_ROW.SALARY < LAST_SALARY) THEN
     LEAVE FOR_LOOP;
   ELSE
     SET LAST_SALARY = EACH_ROW.SALARY;
   END IF;

   INSERT INTO SESSION.RETURN_TBL
   VALUES ( I, EACH_ROW.EMPNO, EACH_ROW.FIRSTNME,
   EACH_ROW.LASTNAME, EACH_ROW.SALARY);
   SET I = I + 1;
 END FOR;

 RETURN
   SELECT POSITION, EMPNO, FIRSTNME, LASTNAME, SALARY
   FROM SESSION.RETURN_TBL;
END;

But I can't create it in DB2 Express edition.
In other versions of DB2 this work proper?
I need some like it.

Thanks