IBM Mainframe Forum

by **BillyBoyo** » Thu Apr 05, 2012 3:56 pm

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.

by **deva_048** » Fri Apr 06, 2012 8:11 am

Am not getting the output still. Please reply. In above badrinath posted code getting rc=0 and not displaying output in spool

by **BillyBoyo** » Fri Apr 06, 2012 12:16 pm

You have to show us what you have done, JCL, sort cards and output messages.

by **deva_048** » Fri Apr 06, 2012 2:24 pm

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.

by **BillyBoyo** » Fri Apr 06, 2012 2:57 pm

-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?

by **deva_048** » Fri Apr 06, 2012 4:50 pm

ok thanks got it.

by **Alissa Margulies** » Fri Apr 06, 2012 7:59 pm

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,

by **deva_048** » Mon Apr 09, 2012 10:13 am

Am getting the output in spool but not in dataset getting incompatible lrecl

Select all

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:

Select all

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)

by **deva_048** » Mon Apr 09, 2012 10:28 am

Found it thanks for your support without your help i can't do this task within specified time. Thanks a lot:)

by **BillyBoyo** » Mon Apr 09, 2012 5:13 pm

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?

IBM Mainframe Forum

Need jcl to take unmatched records count to store in dataset

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

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

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

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

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

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

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

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

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

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