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

As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
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.