MAINFRAME - TIP OF THE DAY :
When you specified V for RECFM parameter, LRECL value is largest record in the file plus 4 bytes. These four bytes contain the actual length of each variable length record in the file

I have File1 with LRECL = 1578 and File2 with LRECL = 279.
In file1 I have 10 char Key from 254-263 whereas in File2 it is from 270-279.
I want to join file1 and File2 on Keys and wherever the key matches replace data at location 9-14 in File1 with data from location 1-6 in File2.
While doing this I want to make sure that we dont change any of the data in File1 for non matching keys.
Please help.
here is an example:
File1
data----------------- Key
(9-14)--------------(254-263)
------ --------------0000000001
------ --------------0000000002
ccccc --------------0000000003

My job works fine with DFSORT. If you are getting syntax errors, then I suspect you are using Syncsort (WER messages), not DFSORT (ICE messages). DFSORT supports JOINKEYS syntax that Syncsort does not support.

I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort._________________Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort