RE: OPNQRYF Observation

Also, if you run the OPNQRYF in Debug and press help on the "All access
paths were considered for file ..." message, it will tell you what it did to
open the access path and sometimes offer suggestions on how to make it
better.



Joe Giusto II
Programmer/Analyst
Ritz Camera
Beltsville, MD
301-419-3209 x347
410-813-2812 x347

 -----Original Message-----
From:   owner-midrange-l@midrange.com [mailto:owner-midrange-l@midrange.com]
On Behalf Of Pat Barber
Sent:   Wednesday, May 23, 2001 3:44 PM
To:     MIDRANGE-L@midrange.com
Subject:        Re: OPNQRYF Observation

Get into PDM and execute the CL from command entry(F10) which will
show you the "log" for that event and all prior entries. This will
show most, if not all messages opnqryf generates. To make sure,
recompile the clp to "log" and BEFORE you run the job, chgjob and
make sure you are logging all messages. This should produce a very
detailed log. To get it all in writing, sign off, sign on, run the
job and when you signoff, press F4 and specify LIST which will produce
a joblog in detail in qezjoblog......

A much better way to debug opnqryf is to run it interactively and you
get a little better handle on the results. How many selections are you
using ??? Are you certain the records you are looking for really exist
??

To check yourself, run a CPYF using the same selections and see what
you get..... This will at least prove if the data combinations exist.




+---

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