Re: File/Field Information Counts

To get the usage of a given field in a given file...

select count(*) from myfile where myfield <> ' '

assuming blanks means "no information"

to get usage for all fields of a given file

select
sum(case fld1 when ' ' then 0 else 1 end) as Fld1Use,
sum(case fld2 when 0 then 0 else 1 end) as Fld2Use,
<....>
from myfile

You could, using either the SQL descriptor area (SQLDA) or certain IBM
API's, write a program that determines at run-time the field names and
data types for a given file. Then builds an SQL statement as shown
above to return the information you want.

But why? What possible use is this going to be?

Charles

On Wed, Nov 26, 2008 at 2:06 PM, Rick Klopfer <RIXONE@xxxxxxxxxx> wrote:

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.