Re: OPNQRYF INCORROUT - Incorrect number of records selected

["Neil Palmer" <neilp@xxxxxxxxxxx>]

At the same time they should still order the latest cum package as well
(SF99430).  C8279430 is already 3 cum package behind, and in about 6 weeks
will be 4 behind.  And as they appear to be way behind on PTF's, order
SF99200 while they're at it (Y2K Group PTF for RISC models).

 Neil Palmer         DPS Data Processing Services Canada Ltd.
                                             AS/400~~~~~
Markham,  Ontario,   Canada    ___________          ___  ~
Phone: (905) 474-4890  x303   |OOOOOOOOOO| ________  o|__||=
Cell.: (416) 565-1682  x303   |__________|_|______|_|______)
Fax:   (905) 474-4898          oo      oo   oo  oo   OOOo=o\
mailto:NeilP@DPSlink.com    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
http://www.DPSlink.com        AS/400  The Ultimate Business Server





Dave Shaw <dshaw1@InfoAve.Net> on 99-07-26 11:00:57

Please respond to MIDRANGE-L@midrange.com

To:   MIDRANGE-L@midrange.com
cc:    (bcc: Neil Palmer/Dpslink)

Subject:  Re: OPNQRYF INCORROUT - Incorrect number of records selected




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