Re: Finding an object's usage

Substitution variables can be used all over the place, what I call soft coding.

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.

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