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
mark.austin@xxxxxxxxxx
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:
MichaelQuigley
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
needed
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,
visit:
http://lists.midrange.com/mailman/listinfo/wdsci-l
or email: WDSCI-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/wdsci-l.
“**Confidentiality**
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.
midrange.com
