Re: Finding an object's usage

[Vernon Hamberg <vhamberg@xxxxxxxxxxx>]

Good question - I sought an answer!!

Created a query called VERN/TEST that had file VERN/JOBLOG in the definition.

Created this program VERN/TESTRUNQRY

PGM

RUNQRY     QRY(VERN/TEST)
RUNQRY     QRY(VERN/TEST) QRYFILE((VHCURLIB/JOBLOG2))

ENDPGM

Ran DSPPGMREF and got the following:

   3/16/07               Display Program References
DSPPGMREF Command Input
  Program . . . . . . . . . . . . . . . . . . :   TESTRUNQRY
    Library . . . . . . . . . . . . . . . . . :     VERN
  Output  . . . . . . . . . . . . . . . . . . :   *
  Object types  . . . . . . . . . . . . . . . :   *PGM
Program . . . . . . . . . . . . . . . . . . . :   TESTRUNQRY
  Library . . . . . . . . . . . . . . . . . . :     VERN
  Text 'description'. . . . . . . . . . . . . :
  Number of objects referenced  . . . . . . . :         4
  Object  . . . . . . . . . . . . . . . . . . :     *RUNOPT
    Library . . . . . . . . . . . . . . . . . :       *RUNOPT
    Object type . . . . . . . . . . . . . . . :       *FILE
    File name in program  . . . . . . . . . . :       *RUNOPT
    File usage  . . . . . . . . . . . . . . . :       Output

plus 3 references to IBM service programs.

FYI
Vern

At 10:01 AM 3/24/2007, you wrote:

> If a RUNQRY is in a CL, then shouldn't that compiled CL show up in the GO
> CMDREF?
>
> 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.
>
>
> --
> 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.