1. What is the LRECL and RECFM of File1?
2. What is the LRECL and RECFM of File2?
3. What is the position,length and format of the key in file1?
4. What is the position,length and format of the key in file2?
5. What is the position, length and format of the name field you want to merge in file1?
6. What is the position, length and format of the name field you want to merge in file2?
7. What is the max number of duplicates you expect for each key?
8. Last but not least , please run the following job and show us the entire sysout so that we can determine the level of DFSORT your shop has
And there are no duplicates in file one. Only one customer record/number. The key on both files
0001 aaaaa vv ff gg
0006 cccccc vv
One to many
No dups in file 1
If no records in file 2 then no output record
For every file one, customer record, will have at least one record in file 2 (account type record) however not the other way around. You can not have a account type record without an customer record. And this is the type of records I am working on.
It does not need to be exact as I can take the ball and run with it. But an idea/direction would be great.
Use the following DFSORT JCL which will give you the desired results. Since your file2 is a VB file , you need to accound the RDW making the positions you mentioned 4 bytes greater. So the key in VB file actually starts in position 53 and the values you want are in position 77.