|
|
| Author |
Message |
Gaurav Bhayawala
New User
Joined: 17 Apr 2008
Posts: 5
Location: Pune
|
|
|
|
I have two files.
file-1 : xxxx.yyyy.FFT.FILE1 (Tape File)
file-2 : xxxx.yyyy.VSO.FILE2 (VSAM file)
I want these two files to be merged & create a new sorted file (file-3) which is also a Tape file
file-3 : xxxx.yyyy.FFT.FILE3 (Tape File)
My question is, Can I merge FIL1 & FILE2 directly...? or should I have to first convert in flat files?...
If I can then How...? |
|
| Back to top |
|
 |
References
|
 Posted: Thu Jun 12, 2008 11:17 pm Post subject: Re: I want to Merge VSAM & TAPE file |
|
|
|
|
Skolusu
DFSORT Developer
Joined: 07 Dec 2007
Posts: 234
Location: San Jose
|
|
|
|
Gaurav Bhayawala,
What is the LRECL and RECFM of the both TAPE, VSAM cluster and the output Tape file?
What is the sort criteria? |
|
| Back to top |
|
|
Gaurav Bhayawala
New User
Joined: 17 Apr 2008
Posts: 5
Location: Pune
|
|
|
|
record length of all 3 files are same (200) & RECFM=FB...
Sort criteria is... Sorted by key...which is same for both files.... |
|
| Back to top |
|
|
Skolusu
DFSORT Developer
Joined: 07 Dec 2007
Posts: 234
Location: San Jose
|
|
|
|
Gaurav Bhayawala,
The following DFSORT JCL will give you the desired results
| Code: |
//STEP0100 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN= xxxx.yyyy.VSO.FILE2,
// DISP=SHR
//SORTOUT DD DSN=&&T1,DISP=(,PASS),SPACE=(CYL,(X,Y),RLSE)
//SYSIN DD *
SORT FIELDS=COPY
/*
//STEP0200 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=xxxx.yyyy.FFT.FILE1,DISP=SHR
// DD DSN=&&T1,DISP=SHR
//SORTOUT DD DSN=xxxx.yyyy.FFT.FILE3,
// DISP=(NEW,CATLG,DELETE),
// UNIT=SYSDA,
// SPACE=(CYL,(X,Y),RLSE)
//SYSIN DD *
SORT FIELDS=(....your sort criteria)
/*
|
|
|
| Back to top |
|
|
dick scherrer
Global Moderator
Joined: 23 Nov 2006
Posts: 7471
Location: 221 B Baker St
|
|
|
|
Hello,
Just curious. . . How many records are in the vsam file? |
|
| Back to top |
|
|
|
|
