IBM Mainframe Forum

[dick scherrer]

Hello,

You need to post all of the JCL and sort control statements you submitted along with the complete set of messages (including message ids) generated by the sort step.

[ranga_subham]

I thought SYNCTOOL does this easily........your thoughts please !!

Select all

//STEPONE1 EXEC PGM=SYNCTOOL
//SSMSG    DD SYSOUT=*
//TOOLMSG  DD SYSOUT=*
//IN       DD INPUT.DATA,DISP=SHR
//FIRST    DD SYSOUT=*
//SECND    DD SYSOUT=*
//SYSOUT   DD SYSOUT=*
//TOOLIN   DD *
  SELECT FROM(IN) TO(FIRST) ON(1,2,CH) FIRST USING(RAN1)
  SELECT FROM(IN) TO(SECND) ON(4,2,CH) FIRST USING(RAN2)
//RAN1CNTL DD *
  OUTFIL FNAMES=FIRST
//RAN2CNTL DD *
  OUTFIL FNAME=SECND

Thanks.

[BillyBoyo]

One mystery cleared up anyway.

Although this is "one step" it is two passes and sorts of the file. And will it work, if you don't sort on the minor key?

Do you need the CNTL files?

[ranga_subham]

BillyBoyo, Yes, please let me know your solution to this problem.

Thanks.

[BillyBoyo]

You haven't answered the questions.

For your question, re-read the whole topic.

[Anuj Dhawan]

There are multiple disconnects in this thread. Will try to address as much as I can:

1. This

Select all

//SYSIN    DD *
 SORT FIELDS=(4,2,CH,A)
 SUM FIELDS=NONE
/*

with this as input

Select all

//SORTIN       DD *
A1 B1             
A2 B2             
A1 B3             
A2 B1             

will give you

Select all

A1 B1
A2 B2
A1 B3

as SORTOUT and not what you show, as an example.

2. I, for one, wont' recommend using PipeSort unless you're looking forward to reduce the elapsed time. That's what PipeSort is designed for.

[Anuj Dhawan]

3. Your SYNCTOOL is correct, as far as I can make out of this thread, what error are you getting? If you wanted to say that, the SYNCTOOL Job ended with RC=16 then I'd say - in OUTFIL statement you're missing "S" in FILENAMES. If that's the problem you get, change this

Select all

//RAN2CNTL DD *
  OUTFIL FNAME=SECND

to

//RAN2CNTL DD *
OUTFIL FNAMES=SECND

and all should be well.

If this is not the problem, please explain again and answer the question which have been asked.

[ranga_subham]

Hi Anuj, thanks for identifying the mistake....... its working.

[Anuj Dhawan]

Glad, it helped.