Re: Can I update sql cursor data?

["Michael Ryan" <michaelrtr@xxxxxxxxx>]

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.