SUM FIELDS=NONE in reverse - Get duplicates only

UnicornMaster · New User Joined: 11 Mar 2021 Posts: 8 Location: Canada

Hi,

I want to get duplicates only
This must be in DFSORT, no ICETOOL

Examples :
Input

enrico-sorichetti · Posted: Sat Mar 13, 2021 2:39 am

if You have already chosen the tool, it means that you have done the due diligence
and checked the availability of the needed skills

pretty stupid requirement anyway

nobody will waste time on providing a DFSORT solution when an ICETOOL solution is readily available

www.ibm.com/support/pages/system/files/inline-files/$FILE/sorttrck.pdf

Joerg.Findeisen · Posted: Sat Mar 13, 2021 2:43 am

Rohit Umarjikar · Posted: Sat Mar 13, 2021 2:57 am

Please do research before posting , similar topics are discussed in past on this forum , you need to make a reference and try yourself first and post later if anything not working .
E.g ibmmainframes.com/about6765.html

You can GROUP the records based on key and assign sequence number and when you BUILD just include sequence number > 1. Simple solution to get duplicate records. There are many other ways but so far this should help.

Besides , the link and the solution provided by others should help you too.

Why would you need EMPTY FILE text , it’s indeed an empty already? You can set RC as suggested and act accordingly down the line.

enrico-sorichetti · Posted: Sat Mar 13, 2021 2:59 am

I wonder why Frank always suggested and provided samples for ICETOOL when dealing with duplicates

Rohit Umarjikar · Posted: Sat Mar 13, 2021 3:06 am

ICETOOL does complex tasks in simple steps using functions , ICETOOL to remove duplicate or get duplicates only or get first or last duplicate or many such requirements around can be solved easily using its SELECT functions.

If there was no ICETOOL, more coding and restrictions or passes at some cases , performance wise I don’t think there is any significant difference . - My thoughts

enrico-sorichetti · Posted: Sat Mar 13, 2021 3:47 am

I guess that IBM did not do a good job with ICETOOL marketing and promotion ...
looks like some people still think that ICETOOL is not really part of DFSORT and does not have the same level of reliability

why so many questions with the stupid requirement

Joerg.Findeisen · Posted: Sun Mar 14, 2021 5:13 pm

@enrico: It could have a better reputation indeed. For some things you just don't need the overhead of an extra layer. I also remember of issues in ICETOOL reported by one of our German IBM contact person that was not addressed for about a year.
Basically ICETOOL is good when starting with DFSORT, all that additional clutter is in general only needed in special cases. Although I have to confess it's convenient to have.

UnicornMaster · New User Joined: 11 Mar 2021 Posts: 8 Location: Canada

Hi guys,

Thanks for the replies

The reason why i can't do it with ICETOOL its because i have a lot of other things to considerate that will be too long and useless to explain so i have simplify at his maximum the problem i have

I would love to use ICETOOL with SELECT ALLDUPS or the solution with SUM FIELDS=NONE,XSUM but it doesnt work for the thing i have to do

Thats why i have asked to the community for help because i've search all around the web and i didnt found any solution

I start asking myself if its even possible to do what i want to do

Rohit Umarjikar · Posted: Mon Mar 15, 2021 6:49 pm

XSUM is a unique feature of the SYNCSORT product ONLY. SELECT feature is equivalent of DFSORT and it does more than that.

Second, I suggest not to piece meal the requirements, It is always nice to know the complete problem and one can suggest better approach than this.
I will lock the topic since you have got the solution, if you have a new requirements then start a new post.