Page 2 of 2

Re: Need jcl to take unmatched records count to store in dat

PostPosted: Thu Apr 05, 2012 3:56 pm
by BillyBoyo
  SORT FIELDS=(1,10,CH,A)
  OUTREC OVERLAY=(51:SEQNUM,8,ZD,RESTART=(1,10))


I'm not going to do JCL for you, but here's the sort deck. Run for each of your files to new, extended by 8 byte, files. Put those new files into the JOINKEYS processing.

Re: Need jcl to take unmatched records count to store in dat

PostPosted: Fri Apr 06, 2012 8:11 am
by deva_048
Am not getting the output still. Please reply. In above badrinath posted code getting rc=0 and not displaying output in spool

Re: Need jcl to take unmatched records count to store in dat

PostPosted: Fri Apr 06, 2012 12:16 pm
by BillyBoyo
You have to show us what you have done, JCL, sort cards and output messages.

Re: Need jcl to take unmatched records count to store in dat

PostPosted: Fri Apr 06, 2012 2:24 pm
by deva_048
I dint change anything Watever badrinath posted the jcl same jcl i tried to submit getting rc = 0 not getting output in spool. In that code wat else need to do anything need to change or i have to test in icetool.

Re: Need jcl to take unmatched records count to store in dat

PostPosted: Fri Apr 06, 2012 2:57 pm
by BillyBoyo
-3nadh's code, as he said, is for a later release of Syncsort.

To get it to work, follow what I have suggested to pre-process your files and then put them into that step. What it is doing, to both files, is adding the sequence number which would otherwise have been in the "cntl" files in the JOINKEYS, because your version of Syncsort doesn't support cntl files in JOINKEYS.

Again this topic is extending, have you wondered why?

Re: Need jcl to take unmatched records count to store in dat

PostPosted: Fri Apr 06, 2012 4:50 pm
by deva_048
ok thanks got it.

Re: Need jcl to take unmatched records count to store in dat

PostPosted: Fri Apr 06, 2012 7:59 pm
by Alissa Margulies
JNF1CNTL and JNF2CNTL are supported in Syncsort MFX for z/OS 1.4. In order for them to be honored in SyncSort for z/OS 1.3.2, an additional support fix is required. Please contact Syncsort Mainframe Product Services for the maintenance.

Regards,

Re: Need jcl to take unmatched records count to store in dat

PostPosted: Mon Apr 09, 2012 10:13 am
by deva_048
Am getting the output in spool but not in dataset getting incompatible lrecl

 WER276B  SYSDIAG= 2632446, 3990715, 3990715, 1455675                   
 WER164B  12,892K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,   
 WER164B     32K BYTES RESERVE REQUESTED, 968K BYTES USED               
 WER146B  20K BYTES OF EMERGENCY SPACE ALLOCATED                       
 WER481I  JOINKEYS REFORMAT RECORD LENGTH=  300, TYPE = F               
 WER110I  SORTOUT  : RECFM=FB   ; LRECL=   300; BLKSIZE= 30000         
 WER247A  SORTOUT  HAS INCOMPATIBLE LRECL                               
 WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000                         


Below are the control cards used:
SYSIN :                                             
  JOINKEYS FILE=F1,FIELDS=(1,230,A,240,8,A),SORTED 
  JOINKEYS FILE=F2,FIELDS=(1,230,A,240,8,A),SORTED 
  JOIN UNPAIRED,F1,ONLY                             
  SORT FIELDS=COPY                                 
  OUTFIL BUILD=(1,230,50X)                         

Re: Need jcl to take unmatched records count to store in dat

PostPosted: Mon Apr 09, 2012 10:28 am
by deva_048
Found it thanks for your support without your help i can't do this task within specified time. Thanks a lot:)

Re: Need jcl to take unmatched records count to store in dat

PostPosted: Mon Apr 09, 2012 5:13 pm
by BillyBoyo
Just a last thing. Unless the output is going to tape, then 30000 is a very bad blocksize to use. For a 3390, you will be leaving 20,000+ bytes per track empty. Or, to put it another way, you data is going to require a much greater space allocation than is necessary, because more than 40% of the space allocated is unusable to you.

Your storage management people would, hopefully, pick this up at some point. However, why not put a better blocksize before they come after you without something heavy?