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

You can retrieve the total number of rows (as well as the deleted rows) from
the SYSPARTITIONSTAT catalog view.

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> On Behalf Of a4g atl
Sent: Montag, 9. Juli 2018 17:07
To: midrange-l@xxxxxxxxxxxx
Subject: Re: Is there a way to list all objects in a library using SQL

@Jon
I have used the Systables option only to find it does not have the number of
records in the file. Guess thats because of the member option. Still, IBM
could include the total number of records in a file.

Darryl

On Sun, Jul 8, 2018 at 7:42 PM Jon Paris <jon.paris@xxxxxxxxxxxxxx> wrote:

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

--
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

--
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