Page 1 of 1

Problem with the CURSOR Fetch

PostPosted: Mon Nov 03, 2008 3:48 pm
by sm364
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.

Re: Problem with the CURSOR Fetch

PostPosted: Tue Nov 04, 2008 3:03 am
by dick scherrer
Hello and welcome to the forum,

See if the info here
http://www.ibm.com/developerworks/db2/l ... index.html
will help.

Re: Problem with the CURSOR Fetch

PostPosted: Tue Nov 04, 2008 6:44 pm
by sm364
thanks dick

Re: Problem with the CURSOR Fetch

PostPosted: Wed Nov 05, 2008 2:11 am
by dick scherrer
You're welcome :)

d