IBM Mainframe Forum

Hi All,

I have to remove duplicates from a flat file. I tried using SELECT (DFSORT) along with LASTDUP it removed the duplicates as expected. The sort card was like this.



But, the problem is, there were few records like this which had duplicates.



For the above record, it has removed all the data and it has given only MAILWER. Is there a way I can get the proper record.

My record length is 800.

Thanks,
Viswa..

hard to believe, that any SORT flavor would drop on its own part of a record

Hello,

What do the informational messages show?

It may help if you post the complete JCL and control statements.

Hello Mr. Scherrer,

I'm not getting any error messages and the JCL goes with RC 0. Here is the JCL..



Hello Mr. Enrico,

I don't think sort is doing it wrong ! I'm 90% sure I'm going somewhere wrong ! so, thought of checking with experts..

Thanks,
Viswa..

definitely the control statements and the sysout. Sample input/output would be good.

What the heck is

SELECT(DFSORT)

?

Hello,

"Some" informational messages Are generated, unless they have been discarded somehow.

Hi Nic,

TS is just saying SELECT was used, I believe.

Then why mention DFSORT when we are in the Syncsort section of the forum? The (conveniently forgotten/not found) messages would have told us.

Hi ,

My apologies, I didn't notice a seperate section for DFSORT. If someone could please move this topic to DFSORT it will be helpful !

Thanks,
Viswa..

using as output the same dataset used for input is looking for troubles
usually unpredictable behavior

try again using the proper approach ( a different output dataset )