RE: [EXTERNAL] Re: Is there a way to list all objects in a library using SQL

Hi Darryl
I don't believe you mentioned what release you are on, but on V7r1 I use the following SQL script, to show what files have deleted records (candidates for REORGS)
You also may want to check out the following
http://ibm.biz/DB2foriServices




Select Table_schema, Table_name, Table_partition,
Number_rows,
Number_Deleted_ROWS, DATA_SIZE,
Variable_length_size, Number_Distinct_Indexes
FROM QSYS2.SYSPARTITIONSTAT
WHERE Number_Deleted_ROWS > 0

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of a4g atl
Sent: Monday, July 09, 2018 11:07 AM
To: midrange-l@xxxxxxxxxxxx
Subject: [EXTERNAL] 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