Re: File/Field Information Counts

Thanks to all that replied. We believe we have found a solution...

The "business value in this information" is important to us as we go thru an
ERP conversion.

Cheers!

--Rick



----- Original Message -----
From: rob@xxxxxxxxx
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: Wed, 26 Nov 2008 14:26:50 -0500
Subject: Re: File/Field Information Counts

First, let's see if we can spin this off on a tangent... (kidding) But
you get into the argument as to what qualifies as "information". Null
fields vs. default values. Record id fields, etc.

But, no, I really do not see any easy way to do this. Nor do I see a
business value in this information.

Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From:
Rick Klopfer <RIXONE@xxxxxxxxxx>
To:
midrange-l@xxxxxxxxxxxx
Date:
11/26/2008 02:19 PM
Subject:
File/Field Information Counts
Sent by:
midrange-l-bounces@xxxxxxxxxxxx



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.



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