|
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?
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.