Posted: Fri May 08, 2009 10:46 am Post subject: Merge Jcl
Hi i want to merge a file with a particular key which is duplicate and also to sum up a particular field of all the duplicate key. also i need to take rest of the field from the first duplicate key record
Example : Key is first 5 bytes + 10 th bytes and i want to sum up the 8th field
Joined: 18 Feb 2006 Posts: 812 Location: San Jose, CA
Posted: Fri May 08, 2009 8:06 pm Post subject:
Your description and example are unclear.
What do you mean by "10th bytes" - what do you mean by "8th field"?
Please indicate which values you want to use as the keys (is it '11111' and '1' in the first three records and '22222' and '2' in the last 2 records). Please indicate which values you want to sum - I don't see how you got a total of 678259 from any of the values shown.
Is your input really as shown? Are there really blanks in between the fields?
You need to do a much better job of showing your example of input and output and explaining what you want to do.
Giving the starting position, length and format of each "field" would help. _________________ 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