• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Callable Statement - Cursors

 
samson
Greenhorn
Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
i am writing a stored procedure in DB2 which returns a resultset with values from different tables.
i want to access this stored procedure.How do i do it?( DB 2 users cursors to get the resultset)
Also should the cursor be left in open state in DB stored procedure?. Should i have the resultset as outparameter or will be directly be assigned to resultset when i execute the stored procedure from java application.
 
Dave Vick
Ranch Hand
Posts: 3244
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
samson
Welcome to the Java Ranch, we hope you�ll enjoy visiting as a regular however,
your name is not in keeping with our naming policy here at the ranch. Please change your display name to an appropriate name as shown in the policy.
Thanks again and we hope to see you around the ranch!!
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic