Re: Get list of library objects and their sources

[Rob Berendt <robertowenberendt@xxxxxxxxx>]

Yes there is an SQL for that.
There are two places I would look for the appropriate SQL.
The first is the list of SQL services.  This lists each SQL service and, if
it's new or altered, what release and/or ptf you'll need.  This is at:
https://www.ibm.com/support/pages/ibm-i-services-sql
The second source is the Knowledge Center appropriate for your release of
the OS.  Since I am running 7.5 I would use (play close attention to the
URL) https://www.ibm.com/docs/en/i/7.5
In the Knowledge Center, drill down into Database, Performance and query
optimization, IBM i Services, Application Services.  For OPM programs
(CRTCLPGM, CRTRPGPGM) use PROGRAM_INFO.  For ILE programs (CRTBNDRPG) use
BOUND_MODULE_INFO.


On Mon, Sep 2, 2024 at 9:58 AM Dave <dfx1@xxxxxxxxxxxxxx> wrote:

> Hello,
>
> Was hoping to do this with a simple dspobjd but the sources aren't listed
> for the programs created with CRTBNDRPG or CL. Presumably there's a SQL
> table somewhere?
> Thanks
> --
> 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.