Count the number of occurances in a input file using Sort

anandkumarrn · New User Joined: 06 Feb 2009 Posts: 23 Location: India

I have a requirement, i have an input file as below

001 11 kajdkasd
002 11 dlksldakas
005 11 sdaslkdl
003 11 jsdkjfksdj
004 02 lkdlas
006 02 ldkasldk
008 13 djksdksd

here I need to get the output as below.

in count 11 : 4
count 02: 2
count 13:1

Regards,
Anand

CICS Guy · Posted: Wed Apr 08, 2009 11:18 pm

Is Count the amount of records for everycode close?

anandkumarrn · New User Joined: 06 Feb 2009 Posts: 23 Location: India

Hi CICS Guy,

Thanks for your timely help,

But i am facing a problem, the output count is not equal to the input records,
say i have a input file with 111964 and in output it gives 111979 records.
so there is a mismatch between these two counts

i am using the below code in my sysin

OCCURS FROM(INFILE) LIST(OUFILE) NOHEADER ON(27,2,CH) ON(VALCNT)

please give us a soln.

Regards,
Anand

anandkumarrn · New User Joined: 06 Feb 2009 Posts: 23 Location: India

CICS Guy · Posted: Thu Apr 09, 2009 12:25 am

With the NOHEADER, I wonder where the 15 extra lines come from.
Have you looked at the first portion and the last portion of the output?

anandkumarrn · New User Joined: 06 Feb 2009 Posts: 23 Location: India

CICS Guy · Posted: Thu Apr 09, 2009 12:40 am

Frank Yaeger · Posted: Thu Apr 09, 2009 4:09 am

Anand,

It's not clear what you mean by the "output count". The count of records in the LIST data set would NOT match the count of input records unless you had NO duplicates. You only get one line per duplicate, so if you had two records with the same key, the input count would be 2, but the output count would be 1.

The sum of the ON(VALCNT) occurrences would equal the number of input records.

Since you said your records are VB, I assume your use of 27 for the starting position includes the RDW in positions 1-4. If not, you need to use 31 as the starting position, but the counts would add up either way.

For example, if I have these input records in INFILE (rrrr for the RDW):

anandkumarrn · New User Joined: 06 Feb 2009 Posts: 23 Location: India

Hi Frank,
i would say my VALCNT and the input records doesn't match,
that is my input records say 1,00,000(1 lakh) and my output count(VALCNT) shows 1,00,015(1 lakh 15 records). so there is a mismatch between the input and the output VALCNT, i am getting this type of error if i have large number of records, i am getting exact count if i have less number of records in my input file.

Frank Yaeger · Posted: Tue Apr 14, 2009 8:47 pm

I can't help you without knowing exactly what you're doing. I don't know what your JCL looks like (for all I know, you could be using concatenation with referback and losing records due to a system restriction on doing that) or what messages you're getting.

I need to see the JES, //TOOLMSG and //DFSMSG output for the job you think has the mismatch. You can send it to me offline (yaeger@us.ibm.com) preferably as an attached text file.