Re: Can I update sql cursor data?

I wonder if the same conditio could be realized using committment control?
Pass through the file, update the fields in the file, re-read from the
beginning, and then rollback the changes.

On 9/3/06, Joe Pluta <joepluta@xxxxxxxxxxxxxxxxx> wrote:

No, I think the original poster wants to open a cursor, make a pass
through
it updating fields as if it were a temporary file but without updating the
actual file, and then re-read the cursor from the beginning with the
changes.

It's an interesting request, but as far as I know it can't be done.

Joe


> From: Michael Ryan
>
> What does "update the cursor data" mean? Do you want to select a row
from
> a
> file into host variables and then change the contents of the host
> variables?
> There's nothing special about that. Just fetch the data and change it.
The
> file won't be updated unless you use the UPDATE or INSERT SQL verbs.
>
> On 9/3/06, 2046 BBQ <2046bbq@xxxxxxxxx> wrote:
> >
> > I tried this statement before, it will also update cursor data and
> actual
> > PF,
> > i just want update the cursor data, not the PF.


--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.