View previous topic :: View next topic
|
Author |
Message |
mohitsaini Warnings : 1 New User
Joined: 15 May 2006 Posts: 92
|
|
|
|
I have two files , where one file is having LRECL = 6 (FB) and another file having LRECL = 90 (FB), File 1 has only one record of length 6 bytes and File 2 can have many records ,
My query is , can I put the value in File 1 which is of length 6 bytes into the header record of File 2 at position 5 leaving rest of the record and fields as it is. Example is as below.
FILE1 :length 6
FILE2 :length 90
Code: |
1-------------------------------------------------------------------------------------------------------------90
VOL1 99999999
D54675376897699996979896986999657
D45645345478957758467367673676467
|
Output :
Code: |
1-------------------------------------------------------------------------------------------------------------90
VOL1123456 99999999
D54675376897699996979896986999657
D45645345478957758467367673676467
|
Can we do it in one step?
Regards,
Mohit
Code'd |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
If your one-record file had something identifiable on, and was a 90-byte record, you could do it with a concatenation and IFTHEN=(WHEN=GROUP and RECORDS=2. Even with no identification, you could do it by generating a sequence number (use more resources that way, though). There's JOINKEYS (more resources).
Or a two-step approach where you generate a symbol/SYMANES for your one-record file, and use the generated symbols on SYMNAMES in the second step. There are examples here. For instance. |
|
Back to top |
|
|
|