Problem with the CURSOR Fetch



IBM's flagship relational database management system

Problem with the CURSOR Fetch

Postby sm364 » Mon Nov 03, 2008 3:48 pm

Hi,

I am facing a problem while am fetching rows from the cursor.

whenever a record is fetched i will be updating the current record and will be inserting a new record with the some of the column values changed.
Problem is that the new row that has been inserted is also getting fetched again, which should not be.
Please help.
sm364
 
Posts: 2
Joined: Mon Nov 03, 2008 3:29 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Problem with the CURSOR Fetch

 

Re: Problem with the CURSOR Fetch

Postby dick scherrer » Tue Nov 04, 2008 3:03 am

Hello and welcome to the forum,

See if the info here
http://www.ibm.com/developerworks/db2/l ... index.html
will help.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Problem with the CURSOR Fetch

Postby sm364 » Tue Nov 04, 2008 6:44 pm

thanks dick
sm364
 
Posts: 2
Joined: Mon Nov 03, 2008 3:29 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Problem with the CURSOR Fetch

Postby dick scherrer » Wed Nov 05, 2008 2:11 am

You're welcome :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post