RE: How can i tell what is call a program

[Alan Shore <ashore@xxxxxxxx>]

Hi John
the one 'gotcha' (maybe) on this procedure is where the program in question is called by  using either the QCMDEXC api or the System() api
I'm not too sure that this would appear in the DSPPGMREF cross reference

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill


-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mark S. Waterbury
Sent: Wednesday, March 30, 2011 11:43 AM
To: Midrange Systems Technical Discussion
Subject: Re: How can i tell what is call a program

Hi, John:

For each "library" on your system that contains applications programs that might CALL one of those vendor programs, issue:

DSPPGMREF PGM(library/*ALL) OUTPUT(*OUTFILE) OBJTYPE(*PGM) +
                OUTFILE(yourlib/DSPPGMREF) OUTMBR(*FIRST *ADD)

Once you have added the cross-reference datas for all of the application libraries to this cross-reference output file, you can query it to determine what programs "use" (CALL) the ones in question. (For this example, I will use the name "TGTPGM01" as an example of one of those 
programs of interest.)   You could use Query/400, or STRSQL, or even 
write an RPG program, to find the results.

The following is an example using SQL:

     select OBJNAM, OBJLIB
         from yourlib/DSPPGMREF
         where OBRNAM = 'TSTPGM01' and OBRTYP = '*PGM'

Does that help?

All the best,

Mark S. Waterbury

> On 3/30/2011 10:35 AM, John.BresinaJr wrote:
> We have a 3rd party application on our system that hasn't been updated in years.  I can see about 18 programs within the 3rd party application library that are being used on a daily basis.  Is there a way I can tell what is calling those programs?
>
> John
--
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.