i have two files which are having different Record lengths (below i am giving the details) and i want to combine 29th,30th and 34th positions data at the end of the record from file1 using the corresponding record (key positions are from 1 to 11) in file2 and creates a new file with out change the record positions(output file shold be as file2 record positions) after merging.
File1: A.B.C (LRECL=300,RECFM=FB)
(key positions are from 1 to 11)
its working fine. Thanks once again for put your efforts on my problem.
according to your logic, the 29-30,34 positions are included at the last of the records( by increasing the length of the record size). actually i want it like "L|DLS|LDJ|F|||LLSD|R1|1|". any way this is also ok by increasing the record size..Thx.
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
rguhanath wrote:
Hi Skolusu,
Many Many Thanks.
its working fine. Thanks once again for put your efforts on my problem.
according to your logic, the 29-30,34 positions are included at the last of the records( by increasing the length of the record size). actually i want it like "L|DLS|LDJ|F|||LLSD|R1|1|". any way this is also ok by increasing the record size..Thx.
Regards,
Nath R.
Change your CTL3 and CTL4 control cards to the following and re-run your job.
so when i am using ur logic it puts delimiter where is the space in the value like |a|df|
exact requirement is....
in the input file we have delimiters are 10 (10 delimiters should be there in each record, because fields count are 11 which are seperated by '|') like..
Joined: 07 Dec 2007 Posts: 2205 Location: San Jose
Nath,
It gets little tricky to preserve the blanks between the delimiters. So we use ALTSEQ to change the delimiter '|'(x'4f' to a Quote (x'7f') inorder to preserve the blanks within the fields. Once we merged the contents from pos 501 then we change the Quote to delimter '|' once again using another ALTSEQ. Change your CTL3 and CTL4 control cards to the following and re-run your job.