MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » January 2014

Re: SQL query by object creation date



fixed

Matt:

The table name you are looking for is QADSPOBJ. But this file in QSYS is not populated; it is just a "prototype."

You need to run this command:

DSPOBJD OBJ(library/*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE) OUTFILE(QTEMP/QADSPOBJ)
or
DSPOBJD OBJ(*ALLUSR/*ALL) OBJTYPE(*ALL) OUTPUT(*OUTFILE) OUTFILE(QTEMP/QADSPOBJ)

and then you can query that file in QTEMP (or of course, you can create this outfile in your own library.)

Hope that helps,

Mark S. Waterbury

> On 1/13/2014 10:31 AM, Matt Olson wrote:
Can someone let me know how you can query by object creation date? I don't recall the system tables to query...

Thanks!







Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact