IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

how to merge two flat files in append manner


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 8797
Location: Welsh Wales

PostPosted: Tue Nov 25, 2008 5:35 pm
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
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: 8797
Location: Welsh Wales

PostPosted: Tue Nov 25, 2008 8:25 pm
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: 496
Location: USA

PostPosted: Tue Nov 25, 2008 9:28 pm
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

Superior Member


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

PostPosted: Wed Nov 26, 2008 1:50 am
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 Developer


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

PostPosted: Wed Nov 26, 2008 2:11 am
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: 496
Location: USA

PostPosted: Wed Nov 26, 2008 2:20 am
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

Superior Member


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

PostPosted: Wed Nov 26, 2008 2:53 am
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare 2 files and retrive records f... DFSORT/ICETOOL 3
No new posts Compare 2 files(F1 & F2) and writ... JCL & VSAM 8
No new posts Write line by line from two files DFSORT/ICETOOL 7
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Merge two VSAM KSDS files into third ... JCL & VSAM 6
Search our Forums:

Back to Top