Re: Is there a way to list all objects in a library using SQL

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

Don't the SYSTABLES contain this information? That would allow SQL to be used without the need to use to the old outfield approach.

I was expecting Birgitta to have proposed this by now.

Jon Paris

www.partner400.com
www.SystemiDeveloper.com

> On Jul 8, 2018, at 7:29 PM, PaulMmn <PaulMmn@xxxxxxxxxxxxx> wrote:
>
> Easier to just use DSPOBJD mylib/*all to an outfile; no need to bother STRPDM (although that works as well).
>
> If you use STRPDM and create a user command, be sure to clear the outfile by hand before you start, and use the *ADD option, so you don't end up with just the OBJD for the last object in the library!
>
> --Paul E Musselman
>
> .
>
>
> At 6:11 PM -0500 7/8/18, Elehti wrote:
> > No. SQL can process files, not libraries. Do STRPDM > 2, for objects in library.  Create User command e.g. DSPOBJD &L/&N   (Parma) to outfile.
> > Shift function (n) key to repeat your command against all objects.
> > Do same with other library. SQL with exception and inner joins both files to get your results
> >
> > On Jul 8, 2018, at 16:09, a4g atl <a4ginatl2@xxxxxxxxx> wrote:
> >
> > I need to list and compare objects on 2 machines to check for missing
> > objects or object with differing level checks.
> >
> > TIA
> >
> > Darryl Freinkel
> -- 
> 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: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate link: http://amzn.to/2dEadiD