IBM Mainframe Forum

I have a requirement like this:

I have two files of length 80.
First file conatins data 09-04-07
second file contains data 08-11-05
As an output I want the second file as 08-11-0509-04-07
I tried using DFSORT with overlay parameter
***********************************************************************************************
//SORTOUT DD DSN=FILE1,DISP=SHR
//SORTIN DD DSN=FILE2,
// DISP=SHR
//SYSIN DD *
OPTION COPY
OUTREC OVERLAY=(9:1,8)
END
//*
***************************************************************************************************
But the output I am gettin is 09-04-0709-04-07

Can anyone tell me how to arrive at the correct output using dfsort? It is urgent

Thanks in advance

Sorry!!! in my previous post sortin , sortout got swapped..

//SORTIN DD DSN=FILE1,DISP=SHR
//SORTOUT DD DSN=FILE2,
// DISP=SHR
//SYSIN DD *
OPTION COPY
OUTREC OVERLAY=(9:1,8)
END
//*

A straight copy is totally destroying your FILE1....... The only thing that's going out to FILE1 is the contents of FILE2....
Is there some key where you are matching? Or is FILE1 an identical record for record copy of FILE2 except for the date?

file1 is an identical layout of file2. there is no such key in any of the file

Well, you will have to use some sort of (splice?) logic to get both records side-by-side in the sort in order to put some of the info from the one into the other.....

i want to achive it using sort rather than ICETOOL..........

Indranil28 wrote:i want to achive it using sort rather than ICETOOL..........

No major difference, they are both part of the IBM Sort package.....
Why one over the other? Some "standard" or "requirement"? Or just practicing and learning new tricks?


"Create files with matching and non-matching records" in Smart DFSORT Tricks could be used, pick only the matching (since there is no non-matching) and use a sequence number on input to create a siimple key if needed......

indranil28,

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

Dang Frank, If I'd understood that it was a constant, I wouldn't been so far off base....

I'm not sure what you mean by a "constant". I'm using the first 8 bytes from the first record in each file. Those values can change and the job would still work. I edited my post to make that clear.