I have a job in which I need to Sort & count the number of times a certain combination occurs in the input file & write the count to the O/P.
The Input will look like this:
The Exception Code is at 1:10,CH & the Brand is at 24:3,CH
I need the Count to be taken on a unique combination of Excp-Code & Brand, & I need the O/P to be in a formatted manner like this:
Excp-code Brand Count
11.13.10 ghi 2
11.13.10 def 1
12.12.10 def 1
13.11.10 abc 1
It is possible by using the SORT Utility. Actually, there is already a job similar to this requirement specified here(http://ibmmainframes.com/about28482.html), posted by Frank Yaeger. I just need to modify the Control Cards to include the second parameter for Sort function, as well as display it.
If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from: