IBM Mainframe Forum

Hi

I'm very new to this and would love to hear if this is possible to achive and how to solve it.

My file is:


Now, is it possible in my JCL to add a sort that sorts and reduce my file?

The output should be something like this:


The file is sorted by userid, acct and note.
And duplicates (where userid, acct, and notes are same) we remove the the line and sumerize all costs together (see -10 and +10 we get 0).

Is this possible?

How do I solve this? Do you have any good sort manual?

Please advice

Thank you.

As you have posted in the DFSORT forum, I shall presume until it is shown otherwise that you indeed have DFSORT, and not Syncsort, CA-SORT, Sort of a Different Colo(u)r, or some other product.

The DFSORT programming manual is here. Read it. This is an extremely elementary task, even by the standards of software engineers; if you cannot figure it out on your own, your prospects for a career in the IT industry are dim indeed.

The DFSORT Getting Started is here. You will find examples. You need SORT and SUM.

The manuals in the links are also available as PDFs.

use the following DFSORT JCL which will give you the desired results

Thank you all for the urls !
and for the solution skolusu!