File Comparison (Another problem)
Posted: Fri Sep 07, 2012 2:51 pm
I have a new problem. File comparison has to be done between two files. Both contains 4 million records.
File1 having record length around 7000 bytes.Eg:(Here columns are like ID,animal,flower,fruit etc)
10001 cat rose apple........
10002 dog tulip orange......
File2 having record length around 4000 bytes.Eg:(Here columns are like ID,fruit,animal,flower etc)
10001 apple cat rose......
10002 orange dog tulip....
Now I have to compare first 4000 bytes for both files. But these column positions may be changed. Copybooks will be provided. Which is the best way to compare such files??
File1 having record length around 7000 bytes.Eg:(Here columns are like ID,animal,flower,fruit etc)
10001 cat rose apple........
10002 dog tulip orange......
File2 having record length around 4000 bytes.Eg:(Here columns are like ID,fruit,animal,flower etc)
10001 apple cat rose......
10002 orange dog tulip....
Now I have to compare first 4000 bytes for both files. But these column positions may be changed. Copybooks will be provided. Which is the best way to compare such files??