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 gkittelson 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
May 3, 2005
25
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
Status
Not open for further replies.

Similar threads

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

Part and Inventory Search

Sponsor

Back
Top