IBM Mainframe Forum

Hello ,
I have an urgent requirement..I have the following data..

aaaa 11 2
bbb 44 3
aaa 22 4

I need to remove the duplicates and add the sum....
The output shld be as below
aaa 33 6
bbb 44 3
Can someone plse help...

Hello,

If this is truly urgent, you have hopefully started writing some code.

It is completely inappropriate to post "urgent requirements" on this forum. . .

d

Since this is "urgent", you should have spent some more time giving the details of your requirement.

What is the RECFM and LRECL of your input file? What is the starting position, length and format of each field?

Assuming that the first field is in positions 1-3, the second field is in positions 9-10 and the third field is in position 14 (which I doubt is the case), you could use these DFSORT control statements:



If my assumptions are wrong, you need to give the correct information.

Thanks Frank for a quick response...

I have few questions:
-->what is it which is removing the duplicate data?
Coz when I m running the job not all duplicate data is being removed.
-->Also many times I m getting S0c4 abend and when I do couple of reruns it works fine...there seems to be something which I m missing..
Please help..

The below is the abend..
ICE185A 0 AN S0C7 ABEND WAS ISSUED BY DFSORT, ANOTHER PROGRAM OR AN EXIT (PHASE S 1)

I understood that the sum parameter is removing dups..But it's not removing all dups for my dataset.

Frank Yaeger wrote:Since this is "urgent", you should have spent some more time giving the details of your requirement.

Perhaps if you gave Frank the relevant information, a solution could be found faster.

Sigh.

The SUM statement keeps one record from each set of duplicates and adds the indicated fields from that set of duplicates.

An S0C7 is probably caused by using SUM for "bad" data. As I said, I assumed you had CH and ZD data in certain positions, but you probably don't. You need to tell me the layout of the records, that is, starting position, length and format of each field.

Hello,
The below is the sample data :
It is to be sorted from 1-8 and the sum shld be frm 11-19 and 22-29



When I trying to use the program it's giving me S0C7..

I don't know how you expect anyone to help you when you don't answer the questions asked and can't describe your requirement correctly.

Again: What is the RECFM and LRECL of your input file?

You say that the sum fields should be from 11-19 and 22-29, but in your example it looks like they are really at 11-17 and 22-28. Please give accurate positions for your fields that correspond to your example. If you don't use the correct positions in your control statements, then it's no surprise you'd get an S0C7.