If the customer number in FILE1 is not in FILE2 then the kobnr (CHAR(10)) should be set as spaces. Customer id can have mulitple kob numbers and all should be in the output file.
ex cutomerid1 has three kob numbers.(kobnr1,kobnr2 and kobnr3)
Please help me with this. I tried the bleow one and it didnt work. I got it from this forum and edited to best of my knowledge. It doesnt work..! it gives the below error.
ICE201I E RECORD TYPE IS F - DATA STARTS IN POSITION 1
ICE126A 0 INCONSISTENT *INREC IFTHEN 0 REFORMATTING FIELD FOUND
ICE751I 0 C5-K24705 C6-K90007 C7-K90000 C8-K90007 E9-K90007 E7-K24705
ICE052I 3 END OF DFSORT
hmmm ... your post is rather confusing. The customerid values you show are 11 bytes whereas you say they're 10 bytes and you have Cusotmeridn in file1 and customeridn in file2 which don't match. Also you seem to be doing something special with 5,4 but I can't tell what considering this would be part of the customerid in 1,10. The reason you got the ICE126A message is because you have 1,10,9:5,6 which means you're trying to put a field at position 9 after you've already put a field at positions 1-10 - that is, you have overlapping fields.
Assuming that your input file1 (FB/133) looks like this: