Hi, I try to find a PIPE solution in the archives but not yet found... (In the MVS world, the joinkeys feature in DFSort is what I would like to do.)
File1 and file2 have 2 columns rdev and cyls. They both have duplicates. File1 is sorted on rdev and need to be preserved. No matter with file2. Based on key cyls I want to match line1 of file1 with the first line in line 2 that has the same cyls value. When picked up, the line in file2 can not be reselected. file1: 6000 10017 6001 3339 6002 3339 File2 8000 3339 8001 10017 8002 3339 Result: 6000 10017 8001 6001 3339 8000 6002 3339 8002 I have a rexx solution but do you see a way to use a PIPE ? I tried a lookup with many combinations... No success. Regards Alain
