IBM Mainframe Forum

Hi

I have the following dataset:



Dataset characteristics are RECFM=FB LRECL=1117

Position 1 - 6 = identifier
Position 8 -16 = Account no
Position 19 - 1117 = other data

I'd like to count instances of Account no, and add that counter to the data, but show each count increment e.g.

Result is:



When I have the result, I only want to keep Account Numbers that have a count > 1, including the originals e.g

Output I would like is:



Is it possible to do this using DFSORT/ICETOOL?

I'd be very grateful for any help. The data in Positions 9 to 1119 needs to be retained for the records that are being kept
Coded for you this time

AllyDick wrote:Is it possible to do this using DFSORT/ICETOOL?

1) Search the SORT manual(s) for: "SECTIONS=…", "COUNT", and also "IFTHEN=…", "BUILD=…"
2) Find existing examples for operations similar to yours
3) Try to adjust standard examples to your own specific needs
4) If something goes wrong, then present here (a) your code, (b) your input data sample (truncated to only critical part!), and (c) your actual results
5) Don't forget to use code tags to enclose all your samples, and code

You say that you want to keep the data from bytes 9 to 1119 but you say th LRECL is 1117 - clarify.

Sorry the rec length is 1119 and not 1117. Thanks

AllyDick wrote:Sorry the rec length is 1119 and not 1117. Thanks

The original question "count records and show the count?" is not related in any manner to the dataset attributes.

I insist: try to read SORT manual(s) and do something by your own - before asking any questions.

sergeyken wrote:

AllyDick wrote:Sorry the rec length is 1119 and not 1117. Thanks

The original question "count records and show the count?" is not related in any manner to the dataset attributes.

I insist: try to read SORT manual(s) and do something by your own - before asking any questions.

Hmm. Where are those manuals kept? I went looking under IBM Manuals but it is like a needle in a haystack.
I am under time pressure to deliver something, so I thought someone here might have a helpful piece of ICETOOL or DFSORT jcl to help me on my way. No problem doing the hard yards if necessary either.

There is a link to the IBM Manuals at the top of each page of this forum; and Googling "dfsort guide" gives you the correct manual as the first item.
Your skillset, as per your profile, includes DFSORT so you should already have the manual bookmarked or downloaded.

When I Google "IBM Manuals", the 1st screen gives http://ibmmainframes.com/manuals.php
One of those should be what you're looking for.