How to get the count in output

notonly4u · New User Joined: 26 Apr 2005 Posts: 87 Location: Hyderabad

Hi,

Iam having a FB LRECL=80 file with records as follows

first 1 to 10 digits has account number zoned decimal (can have duplicates).
64th position will have a flag A or P.

I want to have the number of records of the same accounts with A as well as P in the output.
Is that possible to get it done using sort?

Eg:

0012345678 A
0012345678 P
0012345678 P
0012345678 P
0012345679 A
0012345679 A
0012345679 P
0012345679 P

Output File:
0012345678 A 1
0012345678 P 3
0012345679 A 2
0012345679 P 2

Thanks much for your time.

Regards
Tanden

Frank Yaeger · Posted: Mon Mar 17, 2008 8:54 pm

You can use a DFSORT job like the following to do what you asked for:

notonly4u · New User Joined: 26 Apr 2005 Posts: 87 Location: Hyderabad

Hi Frank,

Thank you verymuch for your kind response.

Regards
Tanden