Re: Finding an object's usage

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

One problem with QRYDFNs is that RUNQRY can be set to point to files 
that are completely different from those in the definition - of 
course, the company that I saw doing this was IBM itself, in iDoctor.

And then there are QMQRYs that use substitution variables for the 
file name - Oy!

Hope this does not confuse too much - heh!

Vern

At 03:34 PM 3/22/2007, you wrote:

> 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?
>
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.