These 2 files basically contain data unloaded from Tables in a DB2 database using DSNUPROC from 2 different development regions. I have to merge these 2 files, remove duplicates from file-1 and load the file back to Region-1 table. There are many child tables which are dependent on this table and the same should be done for those tables also.
I tried and succeeded in creating a Dynamic Sort card which will take all records from File-1 which do not have same characters in 1-10 of file-2 and then merge it with file-2 giving me the desired output. But the file size might increase to more than 10,000 records and the Dynamic Sort card cannot handle that many If then else conditions. I am not sure but i think the limit is 1630.
Any inputs are welcome. Please reply to this if want any more details.