Remove duplicate. copying from flat file to VSAM

Prakash Ramnani

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

eq:
File1 --> Flat file
File2 --> Vsam file
File3 --> Duplicate file

File1
1
1
2
3
4
4
5
6
6

File2
1
2
3
4
5
6

File3
1
4
6

expat · Posted: Sat Jun 09, 2007 2:30 am Post subject:

Use SORT to sort the file on the VSAM key and use SUM FIELDS=NONE to remove duplicate keys.

If you do not want to use ICETOOL, then what else do you suggest to achieve file 3 ?

Prakash Ramnani

The second file i.e the flat file is sorted file..I have no idea how the File3 will be used.

dick scherrer · Posted: Sat Jun 09, 2007 3:03 am Post subject:

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.