Re: SQL FETCH

It's compiled with *NONE.

Using the same program objects but different file
libraries (live and test) it works correctly in test
and not in the other.  I copied the live data into the
test library and then got the error in both.  So I
started deleting records one by one thinking perhaps
there was a bad record - like an unexpected null or
invalid date data.  But it continued to fail until I
deleted all the records.  Then when I started
re-keying records it worked correctly again.

I have no idea yet why this is happening.  As a work
around, I'm closing and reopening the cursor all the
time.

I only know when the users started complaining about
it so when it really started happening I don't know.  

This system is at v4r4.

Thanks for everyone's input.

Phil

--- Peter Dow <pcdow@MailAndNews.com> wrote:
> 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
> +---


__________________________________________________
Do You Yahoo!?
Yahoo! Calendar - Get organized for the holidays!
http://calendar.yahoo.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
+---