Re: System Catalog For Objects

Yes, Sort of like that. That's what I referenced in my initial post. By
the length of time that it runs, it appears to just be doing a DSPOBJD (or
some equivalent) anyway. Also, the change timestamp is one of the things
I'm wanting to retrieve.


Gord




On Wed, Oct 21, 2015 at 8:50 AM, <rob@xxxxxxxxx> wrote:

Sort of like this?
SELECT OBJNAME, OBJTYPE, OBJCREATED,
CAST(LEFT(OBJLONGSCHEMA,10) AS CHAR(10)) AS LIB
FROM TABLE (QSYS2.OBJECT_STATISTICS('ROB','ALL') ) AS x
OBJNAME OBJTYPE OBJCREATED LIB
A *PGM 2015-09-02-12.47.35.000000 ROB
AA *PGM 2015-04-22-13.35.56.000000 ROB
AAA *PGM 2002-01-10-16.49.54.000000 ROB
AAARPG *PGM 2005-07-06-12.50.13.000000 ROB
...

I suggest asking them to add two columns:
LIBNAME VARCHAR(10) System name of the schema
OBJCHANGED TIMESTAMP Timestamp of when the object was changed.

You can try:

https://www-912.ibm.com/r_dir/ReqDesChange.nsf/Request_for_Design_Change?OpenForm



Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Gord Hutchinson <gordm1@xxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 10/21/2015 08:31 AM
Subject: System Catalog For Objects
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Is there a QSYS2 catalog for objects on 7r1? I'm looking for a way to
extract object creation and change information that's quicker than DSPOBJD
to an outfile.

​Google so far hasn't been my friend.​ The closest I can find is the
OBJECT_STATISTICS table function.


Gord



--
Gord Hutchinson
TST Overland Express
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.




--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.