Re: Finding an object's usage

Nick,

To find out which files are used with queries you can convert QRYDFN
objects to QMQRY sources with the RTVQMQRY QRYDFN(*YES) into a SRCPF.

From there you can use FNDSTRPDM or SQL to scan the sources.

Regards,
Carel Teijgeler

*********** REPLY SEPARATOR  ***********

On 22-3-2007 at 12:34 Nick_Radich@xxxxxxxxxxxxxx wrote:

Hi Mark,

Yup, I was looking into that for the Querys if I had to "Roll My Own".  In

the far distant past, I have pretty much written my own at various client 

sites, using DSPPGMREF and DSPDBR.  Along with using Pathfinder and other

tools that were available at those sites.

"Mark S. Waterbury" <mark.s.waterbury@xxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/22/07 12:20 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>

To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: Finding an object's usage

Hi, Nick:

See:
   
http://www.systeminetwork.com/isnetforums/archive/index.php?t-23052.html

for info.about a published article and tool called RTVQRYF that includes

DSPQRYD and DSPQRYF ... this may help you for the *QRYDFNs (Query/400 

queries). 

As others have mentioned, DSPPGMREF to an *OUTFILE will provide info on

what *PGMs use which *FILEs.  DSPDBR to an *OUTFILE will provide 

cross-references such as LFs-to-PFs.  What else did you need?

"rick baird" <rick.baird@xxxxxxxxx> 
Sent by: midrange-l-bounces@xxxxxxxxxxxx
03/22/07 11:59 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>

To
"Midrange Systems Technical Discussion" <midrange-l@xxxxxxxxxxxx>
cc

Subject
Re: Finding an object's usage

no single command (unless you own hawkeye's pathfinder)

DSPPGMREF *ALL will get all program references, but you'll have to look

for queries and other stuff another way.

Hello everyone,

Is there a Command I can run, or a system file I can query, that will

show me all of the objects on my system that reference a particular file?