Joined: 02 Jun 2007 Posts: 5 Location: Rhode Island
Hi,
I am trying to Repro a flat file into VSAM and it is giving SEQUENCE error because the flat file has duplicates records. I want all the duplicate records in a seperate file.
i do not want to use ICE TOOL
Joined: 23 Nov 2006 Posts: 19270 Location: Inside the Matrix
Hello,
Regardless if the records are already in order, you can use the SUM FILES=NONE to remove the duplicates. Once you've removed the duplicates, you might look thru the "smart DFSORT tricks"
http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/ and see if there was anything that would match the 2 files and put the "extras" in a 3rd file.
If you "don't want" to use the built-in features of DFSORT to do what you require (i.e. ICETOOL), you can always use program code. This would be rather trivial code. . . It would also eliminate any use of the sort product.