Re: OPNQRYF INCORROUT - Incorrect number of records selected

[Dave Shaw <dshaw1@xxxxxxxxxxx>]

-----Original Message-----
From: Dave Murvin <davem@drme.com>

>One of my clients is having problems with OPNQRYF not always selecting
>the correct number of records.  Sometimes it selects about ten records
>(more often than not), and sometimes it selects 800+ records.  The 800+
>records is the correct selection. I can submit the job one time and it
>selects 10 records, submit the same job a second time and it selects
>800+ records. The joblogs look identical.  If I run it interactively, it
>might select 10 records 3 times in a row, then select 800+ records, then
>go back to selecting 10 records. They are on V4R3 cum PTF C8279430.
>
>I checked the APARS and SA75673 (PTF SF53242) seems close, but the
>problem queries are not using ALWCPYDTA(*OPTIMIZE).  They do not have
>this PTF installed, but I will suggest that they install it anyway.
>Could this PTF solve additional problems with OPNQRYF, bitmaps and S/O
>indexes?

    <snip>

Don't have them just load a single PTF, have them order PTF package SF99103.
This will bring the database code up to a proper, hopefully working, level.
Cume tapes lag these database packages by months now, so they're not
sufficient in themselves anymore.

---
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
+---