Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization 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.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic