FWIW: I have a stored procedure that given a program (or any of the objects that DSPPGMREF handles), finds all the objects that the program uses, and then recursively finds all that objects that they use, and so on, to an essentially unlimited depth.

You could perhaps modify it to do what you want. It's on Github if you want to look:

https://github.com/SJLennon/IBM-i-RPG-Free-CLP-Code/tree/master/PGM_REFS

Sam



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.


As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.