Re: **How to find display file program relation**

["Dave" <DSchopp@xxxxxxx>]

I thought there were system files that could be queried that already did
this?


"Dan Bale" <dbale@samsa.com> wrote in message
NGBBLKOIELICEFBCHOBCKEPPCFAA.dbale@samsa.com">news:NGBBLKOIELICEFBCHOBCKEPPCFAA.dbale@samsa.com...
> Every night, from the job scheduler, I run a:
>  DSPPGMREF PGM(*ALL/*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE)
>
> I have three logicals built on the outfile:
>  1) Logical by referenced object name, library name
>       Key fields: WHFNAM, WHLNAM, WHPNAM, WHLIB
>
>  2) Logical by program name, library name, ref'd obj.
>       Key fields: WHPNAM, WHLIB, WHFNAM, WHLNAM
>
>  3) Logical by library name, program name, ref'd obj.
>       Key fields: WHLIB, WHPNAM, WHFNAM, WHLNAM
>
> Using the #1 logical, you would be able to instantly find the information
> you are looking for.  If you would like the source for this logical, or
all
> of them, let me know.  (I added meaningful COLHDG's as well, suitable for
> the file utility apps like WRKDBF or DBU.)
>
> - Dan Bale
> (I am *NOT* "Dale"
> http://archive.midrange.com/midrange-l/200105/msg00281.html )
> SAMSA, Inc.
> 989-790-0507
> DBale@SAMSA.com <mailto:DBale@SAMSA.com>
>   Quiquid latine dictum sit altum viditur.
>   (Whatever is said in Latin seems profound.)
>
> -----Original Message-----
> From: rpg400-l-admin@midrange.com [mailto:rpg400-l-admin@midrange.com]On
> Behalf Of Sridhar_Madduri
> Sent: Thursday, June 06, 2002 5:56 AM
> To: 'rpg400-l@midrange.com'
> Subject: RE: **How to find display file program relation**
>
>
> This message is in MIME format. Since your mail reader does not understand
> this format, some or all of this message may not be legible.
> --
> --
> [ Picked text/plain from multipart/alternative ]
> sunil,
>
> by using DSPPGMREF, ur input would be a program and the output would be
the
> list of objects refered by that program.
>
> Use DSPPGMREF on all the programs in a library  ( where the pgms which use
> yr dspf are supposed to be present ) and get the list of all the objects
> referenced, in an outfile.
>
> Then search the outfile for yr dspf.
>
>
> > -----Original Message-----
> > From: Sunil [SMTP:sunil_ramakumar@USSWI.com]
> > Sent: Thursday, June 06, 2002 3:20 PM
> > To: rpg400-l@midrange.com
> > Subject: Re: **How to find display file program relation**
> >
> > Hai
> >
> > I tried that but the program types refered to are *pgm, **srvpgm *module
> > and
> > *sqlpkg -- no *file.
> > So was not able to use it.
> >
> > Regards,
> > Sunil
> > ----- Original Message -----
> > From: <Mike.Barton@pinkroccade.co.uk>
> > To: <rpg400-l@midrange.com>
> > Sent: Thursday, June 06, 2002 2:35 PM
> > Subject: Re: **How to find display file program relation**
> >
> >
> >
> >
> >
> > >Can anyone tell me if there is ant cl command with which I can find
which
> > >all programs are using a particular display file. Like DSPDBR for db
> > files.
> >
> > Sunil
> >      try the DSPPGMREF command (shows all sorts of usages).
> > Mike
> >
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@midrange.com
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
> or email: RPG400-L-request@midrange.com
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>