RE: How to ID what queries use what files?

["Holden Tommy" <Tommy.Holden@xxxxxxxxxxxxxxxxx>]

For example we have this query:
KRQSECCNV1  *QRYDFN   PRODKR      QRY 

Using RTVQMQRY this is the resulting source member:
H QM4 05 Q 01 E V W E R 01 03 06/12/21 14:27                          
V 1001 050 Match secured fields 3 and 4 by user                       
V 5001 004 *HEX                                                       
SELECT                                                                
  ALL       T01.S2USER, T01.S2CODE, T01.S2KEYM, T02.S2CODE, T02.S2KEYM
  FROM      ISDWORK/CKSECRT2 T01,                                     
            ISDWORK/CKSECRT2 T02                                      
  WHERE     T01.S2USER = T02.S2USER                                   
    AND(    T01.S2CODE = 'S'                                          
    AND     T02.S2CODE = 'J')                                          


Thanks,
Tommy Holden


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
GKern@xxxxxxxxxxxxxxxx
Sent: Thursday, December 21, 2006 2:13 PM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: How to ID what queries use what files?

Thanks Tommy - but unfortunately we don't use QRYQRM for any of these 
queries.

I've decided to create my own pgm using a combination of DSPOBJD,
DMPOBJ, 
CPYSPLF, read the spool files and scan for a string and spit it out to a

report.

Regards, Jerry

Gerald Kern - MIS Project Leader
Lotus Notes/Domino Administrator
IBM Certified RPG IV Developer
The Toledo Clinic, Inc.
4235 Secor Road
Toledo, OH 43623-4299
Phone 419-479-5535
gkern@xxxxxxxxxxxxxxxx


This e-mail message, including any attachments, is for the sole use of
the 
intended recipient(s) and may contain confidential and privileged 
information. Any unauthorized use, disclosure or distribution is 
prohibited. If you are not the intended recipient, please inform the 
sender by reply e-mail and destroy this and all copies of this message.