|
View previous topic :: View next topic
|
| Author |
Message |
sindhuvava
Currently Banned
New User
Joined: 05 Dec 2006
Posts: 17
Location: Chennai
|
|
|
|
hi all,
can anyone help me???
how to merge two sequential files fully into another sequential file.
i tried using sort but i am not aware what to be given inside the sysin for merging the entire records in the files.
//STEP1 EXEC PGM=SORT
//SORTIN01 DD DSN=K3060AH.TEST.DTL.FILE5,DISP=SHR
//SORTIN02 DD DSN=K3060AH.TEST.DTL.FILE6,DISP=SHR
//SORTOUT DD DSN=K3060AH.TEST.DTL.FILE
//SYSIN DD *
/* |
|
| Back to top |
|
 |
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
|
|
| Are you merging on any key field or sequence or just copying one file after the other? |
|
| Back to top |
|
|
sindhuvava
Currently Banned
New User
Joined: 05 Dec 2006
Posts: 17
Location: Chennai
|
|
|
|
| have to copy one file after the other so that the output file should contains the entire contents of both the input files |
|
| Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ
|
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi There,
This can be achieved by Concatenating files
You can use following jcl for this
| Code: |
//PRINT EXEC PGM=IEBGENER
//SYSPRINT DD SYSOUT=*
//SYSIN DD DUMMY
//SYSUT1 DD DSN=ur first file name,DISP=SHR
// DD DSN=ur second file name,DISP=SHR
//SYSUT2 DD DSN=o/p file name,
// UNIT=DISK,SPACE=(TRK,(1,1),RLSE),DISP=(,CATLG,DELETE),
// DCB=(LRECL=80,BLKSIZE=800,RECFM=FB) |
|
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
Here's the DFSORT job:
| Code: |
//STEP1 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=K3060AH.TEST.DTL.FILE5,DISP=SHR
// DD DSN=K3060AH.TEST.DTL.FILE6,DISP=SHR
//SORTOUT DD DSN=K3060AH.TEST.DTL.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:
Use [URL] BBCode for External Links |
|
| Back to top |
|
|
|
|
