how to merge two flat files in append manner

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
shailesh.joshi
Member
Posts: 3
Joined: Sat Nov 24, 2007 4:00 pm
Location: Hyderabad

how to merge two flat files in append manner

Post by shailesh.joshi » Tue Nov 25, 2008 8:13 pm

ow 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
Think,communicate and do it.

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Tue Nov 25, 2008 8:57 pm

Here's a DFSORT job that will do what you asked for:

Code: Select all

//S1    EXEC  PGM=ICEMAN
//SYSOUT    DD  SYSOUT=*
//SORTIN DD DSN=...  input file1
//       DD DSN=...  input file2
//SORTOUT DD DSN=...  output file
//SYSIN    DD    *
  OPTION COPY
/*
If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

www.ibm.com/servers/storage/support/sof ... tmpub.html
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

Anuj Dhawan
Moderator
Posts: 1625
Joined: Sat Aug 09, 2008 9:02 am
Location: Mumbai, India

Post by Anuj Dhawan » Wed Nov 26, 2008 3:24 am

Hi,

Being little picky - what if your INPUT-1 is:

Code: Select all

444bbbb 
555cccc
and INPUT-2 is:

Code: Select all

111aaaa 
222bbbb 
333cccc 
what output do you expect ?
Regards,
Anuj

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Wed Nov 26, 2008 3:41 am

"Append" would give output as:

Code: Select all

444bbbb 
555cccc 
111aaaa 
222bbbb 
333cccc  
Are you asking if the OP wants to have the output sorted or merged on the first 3 characters? If so, why not just ask that directly? (The OP made a point of using word "append" in the Subject line and again in the text, so one would assume that's what's wanted, not a sort or merge, but ...).
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others