Can I update sql cursor data?

I tried this statement before, it will also update cursor data and actual
PF,
i just want update the cursor data, not the PF.


date: Fri, 1 Sep 2006 12:11:31 -0400

from: rob@xxxxxxxxx
subject: Re: Can I update sql cursor data?

Like "where current of"?

exec sql declare c1 cursor for select myfield from myfile where
myotherfield='A';
exec sql open c1;
exec sql fetch c1 into :workField;
exec sql Update myfile set myfield=myfield*1.01 where current of c1;
...
exec sql close c1;



Rob Berendt

Subject

Can I update sql cursor data?


I want to change the sql cursor data while using embedded sql in RPGLE
beacaue i don't want to use temp file to store the result data & change
the
necessary data then do something
step like that
1. select data into cursor
2. fetch cursor data
3. update curosr data (not actual relative PF)
4. then fetch cursor data again from top for processing