RE: Tool to analyze queries

["Brad Bird" <BBird@xxxxxxxxxxxx>]

Elena Vázquez,

What I've done during our Y2K analysis is use the RTVQMQRY command on the
*QRYDFN objects.  It'll create a source file member of the query showing the
corresponding SQL statements. Then I can look at the source member for the
file names and field names used in the query.

i.e.;

RTVQMQRY QMQRY(MYQRYOBJ) SRCFILE(MYLIB/MYSRCFILE) ALWQRYDFN(*YES)

<MYLIB/MYSRCFILE(MYQRYOBJ)>

H QM4 05 Q 01 E V W E R 01 03 98/11/13 08:46
V 1001 050 looking for trucks in specific area
V 5001 004 *HEX
SELECT
  ALL       PHVEH, PHTIME, PHLCMI, PHLCDI, PHLCNM, PHCMIL, PHCDIR, PHCNAM,
PHCSTA
  FROM      OMNIDATA/OMPOSHIS T01
  WHERE     PHTIME BETWEEN 961102220000 AND 961103020000
    AND     PHLCST = 'TX'
  ORDER BY  PHLCNM ASC, PHTIME ASC, PHVEH ASC

The FROM shows your file name(s).
The WHERE is the field comparisons, ORDER BY is the sorting, etc.

HTH

-------------------------
Brad Bird                         mailto:bbird@primeinc.com
Prime, Inc.                       http://www.primeinc.com
2740 N Mayfair
Springfield, MO  65803
phone:(417) 866-0001 x3211
fax:  (417) 521-6863


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