View previous topic :: View next topic
|
Author |
Message |
Poha Eater
New User
Joined: 31 Aug 2016 Posts: 74 Location: India
|
|
|
|
Hi Experts,
Could you please help me with a requirement in which i have to copy first 15 bytes (alphanumeric) of File A (LRECL=166, FB) & from column 22 to column 71 (total 50 bytes - alphanumeric) of File B (LRECL=75, FB) to one output file through DFSORT but i am not getting how to achieve that. Please guide me for this.
Input File 1:
Input File 2:
Code: |
XXXXXXXXXXXXXXXXXXXXX1234567890987654321012345678909876543210 |
Expected Output :
Code: |
ABCDEFGHIJKLMNO1234567890987654321012345678909876543210 |
Thanks in Advance !! |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Please search the forum. On the second page there is at least one topic that should give you a starting point.
BTW - they are data sets not files. |
|
Back to top |
|
|
RahulG31
Active User
Joined: 20 Dec 2014 Posts: 446 Location: USA
|
|
|
|
Quote: |
i am not getting how to achieve that. Please guide me for this. |
Use JOINKEYS. Add SEQ number in both files and match by SEQ number (you haven't told but I assume you want one to one relationship).
This should be enough guidance.
. |
|
Back to top |
|
|
Poha Eater
New User
Joined: 31 Aug 2016 Posts: 74 Location: India
|
|
|
|
Hi,
Thank you for providing your inputs. I searched the forum before coming here but didn't find anything concrete on my requirement, may be i didn't search the forum for long enough.
Thank you Rahul, i will proceed as you suggested and i think it will resolve my issue. Thank you for your help |
|
Back to top |
|
|
|