Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

check the cursors result set in a stored procedure

Status
Not open for further replies.
dataforums

dataforums

Programmer
Joined
May 3, 2005
Messages
25
Location
US
Hi all,

I am basically an Oracle Developer trying to migrate oracle procedures to DB2 procedures. I am having a problem checking the result set of the cursor. in oracle we use cursor attributes such as cursor-name NOT FOUND etc...., but how do I check the same in DB2 if the cursor retrived any rows or not?

Please let me soon......

Thanks in Advance!!
 
Sort by date Sort by votes
Maybe the 'Whenever not found go to tag' clause ?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question Question
STRDBG not bringing up options to set breakpoints
Replies
10
Views
1K
chuckw0325
C
C
  • Locked
  • Question Question
Conditionally have a subfile display record blink
Replies
5
Views
1K
mikrom
mikrom
gdg1976
  • Locked
  • Question Question
hi all, input TAB1 COL1
Replies
0
Views
432
gdg1976
gdg1976
C
  • Locked
  • Question Question
AS400 Compile Error
Replies
8
Views
1K
chuckw0325
C
ColeFern
  • Locked
  • Question Question
SQL1224N A database agent could not be started to service a request, or was terminated as a result
Replies
0
Views
589
ColeFern
ColeFern

Part and Inventory Search

Sponsor

Back
Top