RE: IBM Service to provide the same results as DSPPGMREF

Have you had a look at the Bound_SrvPgm_Info Service
https://www.ibm.com/docs/en/i/7.5?topic=services-bound-srvpgm-info-view

Select *
from Bound_SrvPgm_Info
Where Program_Library = 'YOURLIB'
and Program_Name = 'YOURPGM'
and Object_Type = '*SRVPGM';

Mit freundlichen Grüßen / Best regards

Birgitta Hauser
Modernization – Education – Consulting on IBM i
Database and Software Architect
IBM Champion since 2020

"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"
"Train people well enough so they can leave, treat them well enough so they don't want to. " (Richard Branson)
"Learning is experience … everything else is only information!" (Albert Einstein)

-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Steve McKay
Sent: Wednesday, 10 July 2024 02:31
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: IBM Service to provide the same results as DSPPGMREF

Looks like ol' Bob is cheating a little - he's just wrapping the DSPPGMREF command in SQL and doing a CALL QSYS2.QCMDEXC rather than running it from a command line.

Oh, well - thanks for your help, Mark!

Thanks,

Steve McKay
(205) 585-8424
samckay1@xxxxxxxxx



On Tue, Jul 9, 2024 at 4:36 PM Mark Waterbury < mark.s.waterbury@xxxxxxxxxxxxx> wrote:

See:

https://www.linkedin.com/pulse/dsppgmref-sql-table-function-ibmi-bob-c
ozzi/

On Tuesday, July 9, 2024 at 05:18:15 PM EDT, Steve McKay <

samckay1@xxxxxxxxx> wrote:

All -

I'm trying to identify all programs on the system that use a specific
IBM-provided Service Program (*SVCPGM). I can do this using DSPPGMREF
on a particular program or *ALL programs in a library and searching
through the resulting list.

I would prefer to use SQL to get the list of programs - is there a
service that will return this information? I expect to provide the
Service Program name and receive a list of all programs using that program.

Thanks,

Steve McKay
(205) 585-8424
samckay1@xxxxxxxxx
--
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.

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