Rick,
I'm not sure I understand what you mean when you say "fields that have
"information" in them". Surely every field has information in it...
Right?
If you're on V5R4 or later, try iSeries Navigator Databases, drill down
to your file, right click - show statistics.
Estimate of cardinality (on the General tab) gives you some idea of how
many unique values are in this field, as well as many other useful
statistics....
Eric DeLong
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rick Klopfer
Sent: Wednesday, November 26, 2008 1:07 PM
To: midrange-l@xxxxxxxxxxxx
Subject: File/Field Information Counts
I am trying to get the "usage" count on all fields in any file on the
system.
Have looked in QSYS at some of the system files -- but not seeing
anything I can use.
Here is what I need: Say a file has 10 fields per record....and
contains a 1000 records. I need the count of each of the 10 fields
that have "infomation" in them. Not looking for the record count.
Can write a program or use query tools to get this -- simply looking for
an easier way.
Thanks!
--Rick
--
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:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
midrange.com
