That's great guys. Thanks for all your suggestions.

Best regards,

Mark Austin
IT Consultant
Universal Music Publishing Group
Bond House, 347-353 Chiswick High Road, London W4 4HS
Tel: +44 (0)208 742 5520 / Fax: +44 (0)208 742 5699

Universal Music Publishing International Limited
Registered in England. Number 02050403
Registered Office: 347-353 Chiswick High Road, London W4 4HS

-----Original Message-----
From: wdsci-l-bounces@xxxxxxxxxxxx [mailto:wdsci-l-bounces@xxxxxxxxxxxx] On Behalf Of J.Beckeringh@xxxxxxxxxxxxxxxxxxxxxxxxxx
Sent: 10 November 2011 13:48
To: Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries
Subject: Re: [WDSCI-L] Source code

I wasn't aware of SYSPARTITIONSTAT. Nice that IBM managed to sneak members
into the system catalog. But I don't think member type is in there; so
you'd still have to use QUSRMBRD to get the type. I suppose you could wrap
that in a UDF, in order to let SQL do the grouping. Think I'll stick to
the APIs for the time being.

Joep Beckeringh

wdsci-l-bounces@xxxxxxxxxxxx wrote on 10-11-2011 14:21:30:


Wouldn't it be easier to query the SYSTABLES file from the DB2 System
Catalog? You could select those that have FILE_TYPE = 'S'. Then you
could join to SYSPARTITIONSTAT to get the list of members and sum the
NUMBER_ROWS column? I guess you would need to do something if you
it by source type, but that's probably somewhere else in the System
Catalog--I'm just not sure where off the top of my head.
This is the Rational Developer for IBM i / Websphere Development Studio Client for System i & iSeries (WDSCI-L) mailing list
To post a message email: WDSCI-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

The information contained in this e-mail is confidential, may be privileged and is intended solely for the use of the named addressee. Access to this e-mail by any other person is not authorised. If you are not the intended recipient, you should not disclose, copy, distribute, take any action or rely on it and you should please notify the sender by reply. Any opinions expressed are not necessarily those of the company.

We may monitor all incoming and outgoing emails in line with current legislation. We have taken steps to ensure that this email and attachments are free from any virus, but it remains your responsibility to ensure that viruses do not adversely affect you.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by 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 on our policy page. If you have questions about this, please contact [javascript protected email address].