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.
I/P:
----
File 1: KEY + DATA - UNIQUE ROWS
File 2: KEY + DATA - UNIQUE ROWS
O/P:
-----
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.
If you need to create File4 from your original post, let me know and I can modify this job and provide the REFORMAT and OUTFIL statements to accomplish that.
O/P NEEDED:
--------------
2009-10-051000
2009-10-062000 --> 2000 key in file 2
matches with file1.
So this record is taken from File2.
2009-10-053000
2009-10-054000
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.
The SORT logic which i gave is not working right now.
But igave hte i/ps which i have and o/p which is needed.
Could you please check and let me know if we can do this in SORT.
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