Re: Finding an object's usage

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.