View previous topic :: View next topic
|
Author |
Message |
Gaurav Bhayawala
New User
Joined: 17 Apr 2008 Posts: 14 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 |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007 Posts: 2205 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: 14 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
Senior Member
Joined: 07 Dec 2007 Posts: 2205 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
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Just curious. . . How many records are in the vsam file? |
|
Back to top |
|
|
|