|
View previous topic :: View next topic
|
| Author |
Message |
Prakash Ramnani
New User
.jpg)
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
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 |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
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 ? |
|
| Back to top |
|
|
Prakash Ramnani
New User
Joined: 02 Jun 2007
Posts: 5
Location: Rhode Island
|
|
|
|
| The second file i.e the flat file is sorted file..I have no idea how the File3 will be used. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
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. |
|
| Back to top |
|
|
|
|
