Sorting 2 files with different key-positions

Auryn · Posted: Wed Jan 11, 2006 9:44 pm

Some time ago I had the problem to sort two files with different key-positions. I placed my question in an other forum but this is closed now. Maybe Mr. Yaeger remembers me and my problem

Maybe I gonna have some luck here and now? Maybe, meanwhile there's a tool which provides such a feature?
Concrete: Both dataset have an indicator at position 1, length 1. The first Dataset has it's key i.e. at position 10 and the second at position 2, both in length of ten bytes.
i.e.:
First File

Frank Yaeger · Posted: Wed Jan 11, 2006 11:29 pm

Here's a DFSORT job that will do what you asked for. I assumed your input files have RECFM=FB and LRECL=80. If not, the job can be changed appropriately. You'll need z/OS DFSORT V1R5 PTF UQ95214 or DFSORT R14 PTF UQ95213 (Dec, 2004) in order to use DFSORT's IFTHEN and OVERLAY functions. Only DFSORT has these functions, so if you don't have DFSORT, you won't be able to use them. If you do have DFSORT, but you don't have the Dec, 2004 PTF, ask your System Programmer to install it (it's free). For complete details on all of the new DFSORT and ICETOOL functions available with the Dec, 2004 PTF, see:

Use [URL] BBCode for External Links

Auryn · Posted: Mon Jan 16, 2006 2:44 pm

Sorry, that I didn't answer earlier, but:

Hey, phantastic, it works.
Thank you very much.

gowtham_1982 · Active User Joined: 02 Dec 2005 Posts: 109

hai frank,

can you please throw some light on the keyword parameter OVERLAY or help us through a link for the same.

kind regards,

gowtham

Frank Yaeger · Posted: Mon Jan 16, 2006 10:32 pm

OVERLAY is new with the Dec, 2004 DFSORT PTF. For complete details on OVERLAY and all of the other new DFSORT and ICETOOL functions available with the Dec, 2004 PTF, see:

Use [URL] BBCode for External Links