Re: List PGMs Called from MENUs

Vern,
Good point. The DB2 team does such a good job I just assumed that the info from DSPPGMREF was there.

Here's a RFE with comments by CAAC and CEAC
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=137655
Says "Uncommitted Candidate". Hmm, isn't it about time for the new TR's?

There's another one that says "Delivered" but has no details on how.
https://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=102402

Apparently programs are not "related objects" as per
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_74/rzajq/rzajqudfrelatedobjects.htm


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 Vern Hamberg Sent: Wednesday, March 3, 2021 8:31 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. 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 messageemail:MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:https://lists.midrange.com/mailman/listinfo/midrange-l
oremail:MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
athttps://archive.midrange.com/midrange-l.

Pleasecontactsupport@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

--
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