Both input files are in the same length and format and have header and trailer. Header data is same for both whereas the record count in trailer varies.
How can I merge these 2 files into a single file with a single common header and trailer with total count of records in the merged file.
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
sumitha,
I hv no idea about solving this using Natural & MQSeries. How does your problem relate to this forum? If you're trying to achieve this using your SORT product(DFSORT/SyncSort), you need to provide more details:
Product info - DFSORT/SyncSort?
Input/output file attributes
Position and format of key fields
A few sample input/output records showing the relevant fields using "Code" tag.
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
Assuming "merge" really just means concatenate the records from the two files together, and the two files have the same attributes, you can use a DFSORT job like the following to do what you asked for. I assumed the two input files have RECFM=FB and LRECL=80, but the job can be changed appropriately for other attributes.