Re: DFSORT JOINKEYS question: Where to put INREC and OUTREC?

2011-09-16 Thread Farley, Peter x23353
With Frank Yaeger's help I was able to resolve this problem compatibly for both DFSORT and SYNCSORT. For the archives, the sanitized solution is copied below. When SYNCSORT supports the IFTRAIL enhancement introduced by DFSORT PTF UK90026 that will provide a much simpler solution. Thanks once

DFSORT JOINKEYS question: Where to put INREC and OUTREC?

2011-09-15 Thread Farley, Peter x23353
I have developed a JOINKEYS application, but I need to do one more function as part of the process, if it is possible. I am joining two VB files on 2 keys in the fixed part of the VB records and using OUTFIL statements to split the result into multiple output files. In each of the output

Re: DFSORT JOINKEYS question: Where to put INREC and OUTREC?

2011-09-15 Thread Frank Yaeger
:13 AM: From: Farley, Peter x23353 peter.far...@broadridge.com To: IBM-MAIN@bama.ua.edu Date: 09/15/2011 11:10 AM Subject: DFSORT JOINKEYS question: Where to put INREC and OUTREC? Sent by: IBM Mainframe Discussion List IBM-MAIN@bama.ua.edu I have developed a JOINKEYS application, but I need

Re: DFSORT JOINKEYS question: Where to put INREC and OUTREC?

2011-09-15 Thread Frank Yaeger
Peter, Looking at your note again. I suspect that DFSORT's relatively new IFTRAIL function of OUTFIL can help you do what you want more easily (I suspect it wasn't yet available when I showed you the SEQNUM trick). For complete details on DFSORT's IFTRAIL, see:

Re: DFSORT JOINKEYS question: Where to put INREC and OUTREC?

2011-09-15 Thread Farley, Peter x23353
. Peter -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Frank Yaeger Sent: Thursday, September 15, 2011 3:16 PM To: IBM-MAIN@bama.ua.edu Subject: Re: DFSORT JOINKEYS question: Where to put INREC and OUTREC? Peter, Looking at your

Re: DFSORT JOINKEYS question: Where to put INREC and OUTREC?

2011-09-15 Thread Walt Farrell
On Thu, 15 Sep 2011 16:24:43 -0400, Farley, Peter x23353 peter.far...@broadridge.com wrote: Unfortunately I am using one of your competitors' products (Syncsort) and they don't have IFTRAIL yet, though I suppose they will at some point. Speaking entirely personally, and not as a

Re: DFSORT JOINKEYS question: Where to put INREC and OUTREC?

2011-09-15 Thread Farley, Peter x23353
-Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@bama.ua.edu] On Behalf Of Walt Farrell Sent: Thursday, September 15, 2011 4:51 PM To: IBM-MAIN@bama.ua.edu Subject: Re: DFSORT JOINKEYS question: Where to put INREC and OUTREC? On Thu, 15 Sep 2011 16:24:43 -0400

Re: DFSORT JOINKEYS question: Where to put INREC and OUTREC?

2011-09-15 Thread Walt Farrell
On Thu, 15 Sep 2011 17:12:57 -0400, Farley, Peter x23353 peter.far...@broadridge.com wrote: Well, I do also have DFSORT available, but for this application I won't know a priori which product will be used (it may run in different locations on different sysplexes) so I need to keep it