DB2 UDB 9.x and CURSORS

[Ramya Iyer]

Hi, I have used cursors in Oracle and executed them from java, however I am not able to find out the DB2 Type to be set in my registerOutParameter. Can anyone suggest what it should be?


CREATE PROCEDURE getRecords () LANGUAGE SQL
DYNAMIC RESULT SETS 1
BEGIN
DECLARE C1 CURSOR FOR SELECT user_id, pswrd, answ_sec_text FROM indv_temp;
OPEN C1;
RETURN;
END

Regards,
Ramya.