Re: System Catalog For Objects

[Gord Hutchinson <gordm1@xxxxxxxxxxxxxxx>]

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.