I've got a tricky one for those up for a challenge.
I have two input files, and want to create an output file. I'm adding a two digit number to a file containing a header and detail records. Note: the two digit number is dependent on the header and detail records.
INPUT1:
Code: Select all
AAA 7777777777 56
BBB 3333333333 47
CCC 1111111111 84
MMM 2222222222 35
PPP 2222222222 69
Code: Select all
HEADER2222222222
DATAXXXXXXXXXXXXXXXXXXXXXX
DEATIL MMM
DATAXXXXXXXXXXXXXXXXXXXXXX
DATAXXXXXXXXXXXXXXXXXXXXXX
HEADER1111111111
DATAXXXXXXXXXXXXXXXXXXXXXX
DEATIL CCC
DATAXXXXXXXXXXXXXXXXXXXXXX
DATAXXXXXXXXXXXXXXXXXXXXXX
DETAIL CCC
DATAXXXXXXXXXXXXXXXXXXXXXX
HEADER3333333333
DATAXXXXXXXXXXXXXXXXXXXXXX
DEATIL BBB
DATAXXXXXXXXXXXXXXXXXXXXXX
DATAXXXXXXXXXXXXXXXXXXXXXX
HEADER2222222222
DATAXXXXXXXXXXXXXXXXXXXXXX
DEATIL PPP
DATAXXXXXXXXXXXXXXXXXXXXXX
DATAXXXXXXXXXXXXXXXXXXXXXX
DEATIL PPP
DATAXXXXXXXXXXXXXXXXXXXXXX
DATAXXXXXXXXXXXXXXXXXXXXXX
HEADER7777777777
DATAXXXXXXXXXXXXXXXXXXXXXX
DEATIL AAA
DATAXXXXXXXXXXXXXXXXXXXXXX
DATAXXXXXXXXXXXXXXXXXXXXXX
Code: Select all
HEADER2222222222 35
DATAXXXXXXXXXXXXXXXXXXXXXX
DEATIL MMM
DATAXXXXXXXXXXXXXXXXXXXXXX
DATAXXXXXXXXXXXXXXXXXXXXXX
HEADER1111111111 84
DATAXXXXXXXXXXXXXXXXXXXXXX
DEATIL CCC
DATAXXXXXXXXXXXXXXXXXXXXXX
DATAXXXXXXXXXXXXXXXXXXXXXX
DETAIL CCC
DATAXXXXXXXXXXXXXXXXXXXXXX
HEADER3333333333 47
DATAXXXXXXXXXXXXXXXXXXXXXX
DEATIL BBB
DATAXXXXXXXXXXXXXXXXXXXXXX
DATAXXXXXXXXXXXXXXXXXXXXXX
HEADER2222222222 69
DATAXXXXXXXXXXXXXXXXXXXXXX
DEATIL PPP
DATAXXXXXXXXXXXXXXXXXXXXXX
DATAXXXXXXXXXXXXXXXXXXXXXX
DEATIL PPP
DATAXXXXXXXXXXXXXXXXXXXXXX
DATAXXXXXXXXXXXXXXXXXXXXXX
HEADER7777777777 56
DATAXXXXXXXXXXXXXXXXXXXXXX
DEATIL AAA
DATAXXXXXXXXXXXXXXXXXXXXXX
DATAXXXXXXXXXXXXXXXXXXXXXX
---------------
INPUT1:
column 1 and column 3 are unique
column 2 is not unique
INPUT2:
DATAXXXXXXXXXXXXXXXXXXXXXX is some data between the header and detail lines. These are specific to the header and detail lines, and should be kept as is.
OUTPUT:
column 3 of INPUT1 has been added to the header file of INPUT2.
I've tried to split up the task into multiple steps and work at each step with limited success. Been working on this one for a while now, and am getting no where, so any help would be greatly appreciated.
I know this can be done via COBOL/EASYTRIEVE, but if I can achieve this via JCL/DFSORT/ICETOOL, it'd be great.