Re: List PGMs Called from MENUs

date: Wed, 3 Mar 2021 12:37:26 -0600
from: Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>
subject: Re: List PGMs Called from MENUs

Just added my personal vote to the first one.

The 2nd one is 4 years old - glad the 1st one is here - no idea what
delivered means here, and the user comments are kind of strange. Just
submitted a private comment, we'll see if anyone notices, eh?

Vern

On 3/3/2021 8:13 AM, Rob Berendt wrote:

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