Count function in SQL400

[b.reddikumar]

Hello All,

I have a file FILEA with the fileds A,B,C. I need the count for the each field in single SQL statement. Is it possible to get it ?
Report should be as follows

A B C

Count(A) Count(B) Count(C)

[chrisr]

Re: Count function in SQL400

I am not sure you are correctly explaining your requirement. If you count fields A B and C in a file you would get the same value for each.

[danlong005]

Re: Count function in SQL400

Well.... You can... but it wont give you the right answer.

select count(field1) as field1,count(field1) as field2
from mylib.myfile

returns this

       FIELD1          FIELD2 
    2,377,246       2,377,246

It's just a count of how many records are there(except where the field is null). On IBM i(and the like) null fields haven't been super popular like on other machines.

[b.reddikumar]

Re: Count function in SQL400

Hi,

Thank you very much for your replies ... Sorry for missing the clarity in the question.

Yes I need the query when there are null values in the file.

Thanks in advance ...!!!

[B.Hauser]

Re: Count function in SQL400

In this way Count(A), Count(B), Count(C) and Count(*) may return different results.
Count on a column will only count the NOT NULL values within the column. COUNT(*) will count all rows even though there would be a record that consists only of NULL values.
You may have NULL values in a column if COUNT(colunm) and count(*) return different values

Birgitta

[tomliotta]

Re: Count function in SQL400

It would help if you put a set of example rows together with values for fields A, B and C. Then you could show us the result you expect for the three counts. If we have samples and expected results, it's much easier to know what is needed.