Re: IBM Service to provide the same results as DSPPGMREF

[Vern Hamberg <vhamberg@xxxxxxxxxxxxxxx>]

Very interesting, man! I've long looked at a library as some kind of 
table of contents for the objects it contains - perhaps some kind of 
organized list of objects as a way to refer to them collectively.

But Steve's original question still holds - yes, Bob Cozzi's tool can be 
used, it is an SQL "service" provided by someone other than IBM - I 
wouldn't call it cheating, it's what IBM has made possible for us to do.

Of course, wouldn't we all like something "free"? That's in quotes 
because nothing is exactly free, anyhow. So, for now, I suggest Steve 
submit an Idea for this - the Db2 team is quite responsive. I would 
definitely vote for it.

Cheers
Vern

On 7/10/2024 11:40 PM, Mark Waterbury wrote:
> Vern,
>
> You will see the *OIR mentioned occasionally in problem descriptions 
> and for certain APIs, etc.
>
> For example, see:
>
> https://www.ibm.com/support/pages/using-api-qsspqexclnci-clear-unused-object-information-repository-entries 
>
>
> Mark
>
> On Thursday, July 11, 2024 at 12:02:50 AM EDT, Vern Hamberg 
> <vhamberg@xxxxxxxxxxxxxxx> wrote:
>
>
> Hi Mark
>
> I admit to being confused - I don't see anything about OIR information
> in the output file for DSPPGMREF, and not in the documentation - what
> have I missed?
>
> Regards
> Vern
>
> On 7/9/2024 7:52 PM, Mark Waterbury wrote:
> >  Steve,
> > How else can we do this?  DSPPGMREF is the only documented and 
> supported interface to obtain the "*OIR" information (object 
> information repository) for each library.
> > Mark
> >      On Tuesday, July 9, 2024 at 08:31:42 PM EDT, Steve McKay 
> <samckay1@xxxxxxxxx> wrote:
> >
> >  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-cozzi/
> >>
> >>
> >>> 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.
> >>
> >>