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

["Dan Bale" <dbale@xxxxxxxxx>]

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
>