Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Horizontal merging

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CA Products
View previous topic :: :: View next topic  
Author Message
rkarthik22

New User


Joined: 18 Apr 2009
Posts: 47
Location: India

PostPosted: Sun May 17, 2009 11:27 am    Post subject: Horizontal merging
Reply with quote

I have two input file as s:

Input file 1:

F1 F2 F3

1234 ABCD XYZ
5678 EFGH SOT


Input file 2:

F1 F2 F3

4321 PQRS MAKE
5187 TUVW SOUL
9101 GJKL LOP


I am expecting output like:

Output:


F1 F2 F3 F1 F2 F3

1234 ABCD XYZ 4321 PORS MAKE
5678 EFGH SOT 5187 TUVW SOUL
<<<<<<SPACES>>>> 9101 GJKL LOP

Can anyone help me to accomplish this with the help of easytrieve ...horizontal merging..
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun May 17, 2009 2:44 pm    Post subject:
Reply with quote

Hello,

The only time there will be <<<<<<SPACES>>>> inserted is on the last mis-matched record(s)? This cannot happen in ther middle?
Back to top
View user's profile Send private message
rkarthik22

New User


Joined: 18 Apr 2009
Posts: 47
Location: India

PostPosted: Sun May 17, 2009 5:52 pm    Post subject:
Reply with quote

Output:


F1 F2 F3 F1 F2 F3

1234 ABCD XYZ 4321 PORS MAKE
5678 EFGH SOT 5187 TUVW SOUL
<<<<<<SPACES>>>> 9101 GJKL LOP

Spaces should be there...because..there is no third record in input file 1.

i am not matching on any keys.....i just want to merge both the files i.e.horizontal merging with easytrieve
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Sun May 17, 2009 9:48 pm    Post subject:
Reply with quote

Hello,

Then what is the issue?

Define 2 input files and 1 output, read them record by record until end of file, move the info from each file to output and write.

Set an indicator when either file has reached e-o-f and move spaces to that part of the output area.

When both files reach e-o-f, terminate.

If something does not work, post the problem info and someone will be able to assist.
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 -> CA Products All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Merging of two files siva102 DFSORT/ICETOOL 3 Fri Feb 19, 2016 12:36 pm
No new posts Merging records skgupta81 DFSORT/ICETOOL 11 Thu Sep 10, 2015 3:19 am
No new posts Merging file data using ICETOOL kishpra JCL & VSAM 3 Tue Aug 04, 2015 2:15 pm
No new posts Merge horizontal kranthikumarb DFSORT/ICETOOL 1 Fri Aug 29, 2014 8:47 am
No new posts Vetical to Horizontal Transformation vravi DFSORT/ICETOOL 1 Thu Jun 12, 2014 8:31 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us