Re: List PGMs Called from MENUs

Hello Vern, Rob, Mark, Bryan

THANKS for your input & advice

I guess Rob's QSYS2.MESSAGE_FILE_DATA is what I'm looking for.
This will let me compile a list of Menu items and the PGMs they execute
and add those to the table listing calls between PGMs

As for the purpose of this listing, it is not for audits I'm glad to say.

This listing is an indispensable tool for our developers
it lets them find what PGMs are affected when a change is made to a
certain PGM.
(change to parameters comes to mind)

Actually this small util is a piggy riding on the back of an old public
domain utility (FILESCAN?)
that maps files to PGMs and lets you compile all relevant PGMs when a
change to a file is made.
Each night we run DSPPGMREF (into a file) for all PGMs in our software
libraries thus keeping the cross reference current.

I aim to add Menu items to this cross reference


Thanks again to all of you
Gad

On 3/2/2021 8:52 AM, Rob Berendt wrote:

For querying the message files associated with a menu look at:

https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqviewmessagefiledata.htm

Here is a sample:
SELECT
MESSAGE_FILE_LIBRARY,
MESSAGE_FILE,
MESSAGE_ID,
MESSAGE_TEXT
FROM QSYS2.MESSAGE_FILE_DATA
WHERE MESSAGE_FILE_LIBRARY CONCAT MESSAGE_FILE IN(
SELECT OBJLIB CONCAT OBJNAME
FROM table(OBJECT_STATISTICS('*ALLUSR', '*MENU', '*ALLSIMPLE'))
);
You can parse out the menu option from MESSAGE_ID.
The command is in MESSAGE_TEXT.

Add the following to the where clause:
And UPPER(message_text) like('%MYPGM%')

Rob Berendt