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
 

 

how to merge two flat files in append manner

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
dalib123

New User


Joined: 14 Oct 2008
Posts: 7
Location: india

PostPosted: Tue Nov 25, 2008 5:30 pm    Post subject: how to merge two flat files in append manner
Reply with quote

how to append a flat file in the second file with the same structure.
like file1 contains


111aaaa
222bbbb
333cccc


and file 2 contains
444bbbb
555cccc

and the output should be

111aaaa
222bbbb
333cccc
444bbbb
555cccc
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Nov 25, 2008 5:35 pm    Post subject:
Reply with quote

IEBGENER, SORT, a program, many ways.
Back to top
View user's profile Send private message
dalib123

New User


Joined: 14 Oct 2008
Posts: 7
Location: india

PostPosted: Tue Nov 25, 2008 8:21 pm    Post subject: Reply to: how to merge two flat files in append manner
Reply with quote

thanx expat
can you tell how to use these utilities IEBGENER, SORT with the sample code for merge them as append.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Nov 25, 2008 8:25 pm    Post subject:
Reply with quote

IEBGENER lives HERE.

In fact, the whole book is essential reading for almost everyone in the mainframe business.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Tue Nov 25, 2008 9:28 pm    Post subject:
Reply with quote

Try this sort step:

Code:
//STEP1 EXEC PGM=SORT
//SYSOUT  DD SYSOUT=*
//SORTIN  DD DSN=Input.File1,DISP=...
//        DD DSN=Input.File2,DISP=...
//SORTOUT DD DSN=Output.File,DISP=...
//SYSIN   DD *
  SORT FIELDS=COPY
/*
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Nov 26, 2008 1:50 am    Post subject:
Reply with quote

Hi dalib,

To add a little to what has been suggested so far..

At the top of the page is a link to "IBM Manuals". Among these are the Manuals which talk about these stuff..

If you find something in a manual that is not clear, post what you found (and the link to that part of the manual) and your question and someone here will be able to clarify.

Becoming familiar/comfortable with the manuals is invaluable..They are better than us (me for sure) icon_smile.gif
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Nov 26, 2008 2:11 am    Post subject:
Reply with quote

Just to clarify, the manuals you refer to which talk about this stuff (sort) are the DFSORT manuals which apply to DFSORT and DFSORT's ICETOOL - they do not apply to competitive sort products. The DFSORT manuals are freely available online in pdf and bookmanager format for anyone to reference. Manuals for competitive sort products are not available online.
Back to top
View user's profile Send private message
Alissa Margulies

SYNCSORT Support


Joined: 25 Jul 2007
Posts: 500
Location: USA

PostPosted: Wed Nov 26, 2008 2:20 am    Post subject:
Reply with quote

Electronic versions of SyncSort manuals are available for free to any licensed customer. SyncSort customers can request manuals via email at zos_tech@syncsort.com or call 201-930-8260.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Nov 26, 2008 2:53 am    Post subject:
Reply with quote

No comments, Thanks.

-Ad
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts High CPU consumption Job using IAM fi... aswinir JCL & VSAM 15 Thu Dec 01, 2016 8:28 pm
No new posts Match or compare two files in VB Format anatol DFSORT/ICETOOL 14 Thu Nov 03, 2016 7:41 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
This topic is locked: you cannot edit posts or make replies. How to use 2 input files in control c... Gunapala CN DFSORT/ICETOOL 23 Thu Oct 13, 2016 3:42 pm
No new posts How can we create a flat file in JAVA... rakesh.v18 Java & MQSeries 7 Fri Sep 23, 2016 10:46 pm


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