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

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