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
Programmers Voted for below topics. Please Vote for good Posts.
Thank You! for your feedback. Connecting to the server. Please Wait...
Posted: Fri Sep 23, 2011 12:00 am Post subject: Join on keys and replace when matched
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.
here is an example:
Joined: 18 Feb 2006 Posts: 812 Location: San Jose, CA
Posted: Mon Sep 26, 2011 10:04 pm Post subject:
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) - firstname.lastname@example.org
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Cobol Tutorial This cobol tutorial covers most of the important topics like STRING, UNSTRING, COMP, COMP-3.....
DB2 Tutorial DB2 Tutorial focuses on DB2 COBOL Programming. Explains in simple language. Some Chapters are locked, Forum members have free access to these chapters
CICS Tutorial This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming...
JCL Tutorial This is most popular JCL tutorial from mainframegurukul. It does contain important jcl ....
SORT Tutorial This Tutorial covers all important aspects of DFSORT. Has more SORT examples