create file from other 2 files matich key value

RM0C13920 · New User Joined: 16 Dec 2009 Posts: 3 Location: bbbd

I have 2 files.
In file I m having records with many fields along with key of 15 bytes
second file having only 15 bytes key value.
Now I want to create the third file from the record of first file for which key value matches in 2 nd file with values of 3 fields updated with new values. Remaing record will be same as first file record for those matching records

I want to use ICETOOL fpr this

Skolusu · Posted: Thu Feb 04, 2010 11:05 pm Post subject:

RM0C13920,

1. What is the LRECL and RECFM of File 1 and File 2
2. What is the position and format of the matching keys from both files.
3. Show us a sample input and desired output explaining all the rules involved in matching.

Also check out the following DFSORT Smart tricks

# Create files with matching and non-matching records
# Join fields from two files on a key
# Join records on a key with missing fields
# Join fields from two files record-by-record

http://www.ibm.com/support/docview.wss?rs=114&uid=isg3T7000094

You should be able to build your solution on those examples