Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Copy selected columns from 2 input files to 1 output files

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
Poha Eater

New User


Joined: 31 Aug 2016
Posts: 45
Location: India

PostPosted: Thu Nov 02, 2017 3:43 pm    Post subject: Copy selected columns from 2 input files to 1 output files
Reply with quote

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:


Code:

ABCDEFGHIJKLMNO



Input File 2:


Code:
XXXXXXXXXXXXXXXXXXXXX1234567890987654321012345678909876543210


Expected Output :

Code:

ABCDEFGHIJKLMNO1234567890987654321012345678909876543210


Thanks in Advance !!
Back to top
View user's profile Send private message

Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2130
Location: UK

PostPosted: Thu Nov 02, 2017 3:54 pm    Post subject:
Reply with quote

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
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 447
Location: USA

PostPosted: Thu Nov 02, 2017 7:57 pm    Post subject: Reply to: Copy selected columns from 2 input files to 1 output files
Reply with quote

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
View user's profile Send private message
Poha Eater

New User


Joined: 31 Aug 2016
Posts: 45
Location: India

PostPosted: Fri Nov 03, 2017 12:19 pm    Post subject: Copy selected columns from 2 input files to 1 output files
Reply with quote

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 icon_biggrin.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Copy Group of Records scorp_rahul23 DFSORT/ICETOOL 1 Sun Jan 13, 2019 9:17 am
No new posts Add week number to a file name or rep... tejdeep0274 JCL & VSAM 2 Thu Jan 03, 2019 6:49 am
No new posts Storing SORTOF files in a PDS ajithajt SYNCSORT 3 Thu Dec 06, 2018 12:27 pm
This topic is locked: you cannot edit posts or make replies. DFSORT output in CSV for data spans i... hiravibk DFSORT/ICETOOL 3 Tue Nov 13, 2018 7:55 pm
No new posts REFORMATTING WITH JFY CLOBBERING OUTP... speermb DFSORT/ICETOOL 12 Thu Nov 08, 2018 7:20 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us