Re: SQL FETCH

Hi Mark, Dave, Phil,

Assuming that Mark and Dave's solution solves the problem, why did it work
for months before failing? Did they just fail to notice it? Did a PTF or
release upgrade change the behavior? Just a recompile forgetting to specify
*NONE? I'm always suspicous when a program that hasn't been touched for
months suddenly starts to behave differently. To paraphrase Albert E, "IBM
doesn't play dice with OS/400's behavior!" Or do they?

Curious,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax


----- Original Message -----
From: "M. Lazarus" <mlazarus@ttec.com>
To: <RPG400-L@midrange.com>
Sent: Thursday, November 16, 2000 7:44 PM
Subject: Re: SQL FETCH


> Phil, Dave,
>
>   You can specify WITH NC to explicitly turn off commitment control.  Then
> you don't have to worry about remembering it on the compile.
>
>   -mark
>
> At 11/16/00 07:23 PM -0500, you wrote:
> >Recompile the program with Commitment Control *NONE.
> >
> >That should do it,
> >Dave
> >
> >----- Original Message -----
> >From: "Phil Groschwitz" <sublime78ska@yahoo.com>
> >To: <RPG400-L@midrange.com>
> >Sent: Thursday, November 16, 2000 2:47 PM
> >Subject: SQL FETCH
> >
> >
> > > I have a display file pgm using embedded sql.  Has
> > > been in place for months with no problems.  Now,
> > > however, when a record is updated (like by another
> > > user) and the first user updates the screen, which
> > > does a FETCH FIRST, then clears the subfile, then
> > > loads the subfile using FETCH NEXT, the changed record
> > > reflects the original value.  Any added records are
> > > not retrieved.  Only when the cursor is closed and
> > > reopened does the correct data display.
> > >
> > > Any ideas?
> > >
> > > Thanks, Phil
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---