I want to compare between two files and put the matching data into one file and the non matching data into another.
The first file is a VB file which has 34 bytes of data which looks like this
The key is from position 13 in the VB file and position 1 to 9 in the second file
I want to take out the common records based on the key in both the files and put the record from the second file's 11th position to another file.. These would be the common records, and if I do not find a match I would want the entire record from the first file to be present in another file.
For example for the key 483832127 we have a match in the first file in the second record so I would want my match output file to have 13349500374 and rest of the records from the first file which do not match should come to the non match file in the same layout as my first file.
Hi kolusu,
Thanks for the reply
When I try to run this sort job, I get an error
Code:
E1 - DSS20011E - DD 'SORTIN' WAS NOT ALLOCATED.
E2 - DSS11043E - NO SORT OR MERGE CONTROL STATEMENT WAS FOUND
I am not sure if this has something to do with the installation of DFSORT, We have ICETOOL in our shop, can this be done through that or am I missing something here.
Also can you let me know what does the ? indicate in
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
sudib19 wrote:
When I try to run this sort job, I get an error
sudib19,
Nope you did NOT run the job. They are your JCL syntax checker messages which never are up to date with the latest features of DFSORT. So ignore them and run your job.
sudib19 wrote:
Also can you let me know what does the ? indicate in
Code:
REFORMAT FIELDS=(F1:1,4,?,F2:11,11,F1:5)
Check this link which explain in detail about joinkeys