RE: How to ID what queries use what files?

["Dunfee, Randy" <rdunfee@xxxxxxxxxxxxx>]

Also scan for any QRYFILE parms on all RUNQRY cmds, as these can
override the libs, files, and members defined in the *QRYDFN.  And even
when not changing/overriding the files or members, specifying QRYFILE
parms with *LIBL on all RUNQRYs allows the achievement of run-time
lib/file resolution that someone was just wishing for. 

Randy Dunfee
Dunfee Business Automation, Inc.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
GKern@xxxxxxxxxxxxxxxx
Sent: Thursday, December 21, 2006 3: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.