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

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

2011-09-15 Thread Frank Yaeger
Peter, I'm not sure exactly what you're trying to do, but I can think of two ways to get a count like that. One would be to use an IFTHEN WHEN=INIT clause in each OUTFIL before the other IFTHEN clauses to insert the sequence number (of course, you have to adjust the positions in the subsequent

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