RE: Query (QQQQUERY) analysis logging

["Shaw, David" <dshaw@xxxxxxxxxxx>]

Michael,

Yes.  To get those messages, just STRDBG before running the query (make sure you
specify UPDPROD(*YES) if you need it).  Sequel's audit module can automagically
capture and save these for your Sequel views and reports.  If you're on V4R4,
there's a way to specify this either system-wide or for individual runs, using a
query options file called QAQQINI.  There's an article about that in the January
issue of News/400, I believe, authored by Kent Milligan if I recall correctly.

I hope this helps!
Dave Shaw
Spartan International, Inc.
Spartanburg, SC

-----Original Message-----
From: Schlemme, Michael C. [mailto:mschlemme@frpaper.com]

Hello all, 
Could someone refresh my memory?  When I run anything that uses QQQQUERY
(Sequel's, OPNQRYF, IBM query, etc), I have seen, and would like to see again, a
'log' the system creates saying things like "An access path was built over FILEA
using FIELDA.  To eliminate the access path build, create a logical over FILEA
by FIELDA".  The wording was something like that.  I think I remember the words
"access plan" or "build plan" relating to this.  Anyone have any idea what I'm
talking about ?
+---
| 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
+---