I tried to check in Forum. But i could not figure out how to do.
Please help me with this. Here is how my I/P is and O/P needed.
I want to do it in JOINKEYS. But any other approach is also good for me.
If possible, please give me solution in one step.
File 1: KEY + DATA - UNIQUE ROWS
File 2: KEY + DATA - UNIQUE ROWS
File 3: (File 1 data not in File 2) + (File 2 data not in File1)
File 4: File 2 data not in File1
Here is a SyncSort for z/OS job that will produce the requested results.
Since you did not specify the RECFM or the position and length of the KEY fields, I assumed FB with KEY starting in position 1 for length of 5.
2009-10-062000 --> 2000 key in file 2
matches with file1.
So this record is taken from File2.
2009-10-065000 --> This record is absent in File1. So copied from File 2.
All i trying to do is, read all data from File1 and applies inserts/updates from file2 and write to a new file.
Let me know if i need to explain better.
Glad I could help... when you clearly specify your requirements, as you had done here in your 3rd post, including sample input, desired output, and what you have tried, it is much easier to provide you with a proper solution