Re: OPNQRYF mixed results

[Dave Shaw <dshaw1@xxxxxxxxxxx>]

-----Original Message-----
From: John Bussert <jbussert@stecnet.com>


>I am having a strange problem that I would like to know if anyone else is
>experiencing.  At one client (seems to be only one...) we have some reports
>that use OPNQRYF, that select records and print them.  Fairly conventional,
>there is some selection and sorting going on in the query, but nothing
>extravagant.  The problem we are having is that one day I can run the
>reports and the next day, run the same report (on history not current
data),
>and the numbers change.  Actually, what I think is happening is that some
>records are not being selected in one and they are on the other.  We can
>compare the identical reports run on different days, and see that there are
>records not on one and on the other.
>
>I would almost say that it seems, OPNQRYF is not picking up all records on
>one, but later it does.  Unfortunately, this is not something we can
>duplicate until it happens, then running the report again - it gets fixed
>(the records show up).
>
>They are current on PTF's (as of a couple of months ago) on 4.3.  Has
anyone
>else seen or heard of anything like this?

By "current on PTF's" I assume you mean that they put the then-current cume
package on.  I suspect that they probably didn't know to order and install
the DB2 service pack.  I'd suggest getting that (for V4R3 it's SF99103, I
believe) and see if it cures the problem.

---
Dave Shaw, General Nutrition, Greenville, SC
To subscribe to the MAPICS-l mailing list send email to
MAPICS-L-SUB@midrange.com
The opinions expressed may not be my employer's unless I'm sufficiently
persuasive...


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