Re: List PGMs Called from MENUs

This is a great list - I took a look and have to ask, which of these gives you the results of DSPPGMREF? I looked at several of the program-related services and see nothing that lists what references to other objects are included in the output of them. These will not, so far as I can see, will not give Gad what they need for change impact.

I'm happy to be proved wrong on this, as I love that IBM are providing these several services. Is there, in fact, already a service that provides the information that DSPPGMREF does? That would be great. Of course, that is not the only thing, as Gad has shown, needed to know what is affected by program changes. I'm not sure Abstract or Hawkeye have objects used in menus - I'll look at Abstract, which we use.

Cheers
Vern

On 3/3/2021 6:14 AM, Rob Berendt wrote:

As far as querying some big cross reference for DSPPGMREF why not look at these?
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqservicesappsys.htm
They are always up to date and include all the mods up to the minute.

Rob Berendt
-- IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to: 7310 Innovation Blvd, Suite 104 Ft. Wayne, IN 46818 Ship to: 7310 Innovation Blvd, Dock 9C Ft. Wayne, IN 46818 http://www.dekko.com -----Original Message----- From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Gad Miron Sent: Wednesday, March 3, 2021 3:26 AM To: midrange-l@xxxxxxxxxxxxxxxxxx Subject: Re: List PGMs Called from MENUs CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. 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

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email:MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:https://lists.midrange.com/mailman/listinfo/midrange-l
or email:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
athttps://archive.midrange.com/midrange-l.

Please contactsupport@xxxxxxxxxxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link:https://amazon.midrange.com
-- This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options, visit: https://lists.midrange.com/mailman/listinfo/midrange-l or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx Before posting, please take a moment to review the archives at https://archive.midrange.com/midrange-l. Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related questions. Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com