Now I want to write the record of file A into a new outputfile C (LRECL=1200), if the key in file B matches a key in file A, so that file C looks like this:
What is the RECFM of FileA? What is the RECFM of FileB? What is the RECFM of FileC?
Can FileA have duplicate keys within it?
Can FileB have duplicate keys within it?
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
Here's a DFSORT/ICETOOL job that will do what you asked for. I assumed when you said the Sortkey starts on byte 58, you were counting the RDW in positions 1-4 (so the first data byte starts in position 5). If not, then use 62,1200 instead of 58,1200.
Last edited by Frank Yaeger on Wed Nov 19, 2008 1:47 am, edited 1 time in total.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
it didn't work, I always got an error messages saying that cntlout is missing or can not be allocated (I can't recall the correct message).
I searched the internet and found some information, that the reason for this message may possibly be a missing T1 dataset, so I defined a dataset, but that also didn't work.
But I found a "work around" using DFSORT. It had some more steps but i worked.
I can post the JCLs I've tried an the error message tomorrow. Maybe you or some other users can give hints or tell me what mistakes I've made.
You don't need FNAMES=OUT with the latest DFSORT PTF (July, 2008) which I'm running with. You do need it if you don't have the latest DFSORT PTF, which you apparently don't.
Ask your System Programmer to install z/OS DFSORT V1R5 PTF UK90013 (July, 2008). For complete details on all of the new DFSORT and ICETOOL functions available with the April, 2006 PTFs, see:
I've updated my previous post to include FNAMES=OUT to avoid confusion.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
But:
It could be difficult to ask our System Operator to update our system, because we're a big and worldwide company. It's a loooong way (and needs many instances to say "yes") for a "simple developers" to get suggestions realized.
(I hope you can understand what I'm trying to say, because it has been a long time ago since I spoke and written English!)
Yes, I understand the problem with getting things changed in a worldwide company (your English is much better than a lot of what we see here).
For this particular job you can just add FNAMES=OUT. Unfortunately, if you want to use other new DFSORT functions that are only available with the July, 2008 PTF like FINDREP, WHEN=GROUP, DATASORT, SUBSET, etc, you'll be out of luck if you can't get the PTF installed.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort