Re: Easiest way to get a list of objects in a library, with their last-changed date?

ok so how about this,it involves a few steps but should work on older versions
put this in a source file:
https://code.midrange.com/11f259731d.html

adjust the DSPOBJD as needed, or pull it out of the source and run from command line

then RUNSQLSTM SRCFILE(LIBRARY/SOURCE)
SRCMBR(SOURCEMBR) COMMIT(*NONE) NAMING(*SYS)

then RUNQRY *n QTEMP/ZADSPOBJ

i can only test on V7.5 and it ran there


Bryan


James H. H. Lampert via MIDRANGE-L wrote on 9/12/2024 12:33 PM:

On 9/12/24 10:10 AM, Mark Waterbury wrote:

  James,
In STRSQL, you can do:
SELECT * FROM TABLE (QSYS2.OBJECT_STATISTICS('QGPL','*PGM')) as X

Thanks.

While I could not do that directly on the systems of interest (V4R4 and V5R2, with no STRSQL available), I *could* do it on a V7 box where the product was installed.

Turns out I was really after creation timestamp. The object here was to make sure I update everything that needs to be updated, before building a release of a product.

Here's what I ended up with, after a bit of futzing around:

select OBJNAME, OBJCREATED, CREAT00001, CREAT00002  from table(qsys2.object_statistics('AQUESTVIEW','*PGM')) AS
 X ORDER BY OBJCREATED DESC

Could somebody explain what the stuff in the FROM claus does? Is "qsys2.object_statistics" some sort of function that returns a table or a result-set? And what does the "AS X" do?

--
JHHL