Hi
I would appreciate it if someone can tell me if the following can be done with DFSORT:
I have two files:
File1
AAA11111
AAA22222
AAA33333
BBB22222
BBB44444
File2
AAAMMM
AAANNN
BBBOOO
BBBPPP
(The last three characters in File2 are unique.)
I need a join between the two files that will produce the following:
File3:
AAA11111MMM
AAA22222MMM
AAA33333MMM
AAA11111NNN
AAA22222NNN
AAA33333NNN
BBB22222OOO
BBB44444OOO
BBB22222PPP
BBB44444PPP
Each record in File2 is 'expanded' via the first three characters with the corresponding records in File1. The resultant file has 10 records (2x3 + 2x2).
I would appreciate any help/advice with this query.
Thanks
Carlo