Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

DB2 UDB 9.x and CURSORS

 
Ramya Iyer
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!