IBM Mainframe Forum

Posted: **Sun Jul 08, 2012 10:29 am**

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.

Posted: **Mon Jul 09, 2012 3:28 pm**

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.

Posted: **Mon Jul 09, 2012 4:04 pm**

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?

Posted: **Tue Jul 10, 2012 3:28 pm**

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

Thanks.

Posted: **Tue Jul 10, 2012 4:15 pm**

You haven't answered the questions.

For your question, re-read the whole topic.

Posted: **Thu Jul 12, 2012 10:50 am**

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.

Posted: **Thu Jul 12, 2012 10:55 am**

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.

Posted: **Thu Jul 12, 2012 2:45 pm**

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

Posted: **Thu Jul 12, 2012 6:11 pm**

Glad, it helped.

IBM Mainframe Forum

SUM FIELDS=NONE at file level

Re: SUM FIELDS=NONE at file level !!

Re: SUM FIELDS=NONE at file level !!

Re: SUM FIELDS=NONE at file level !!

Re: SUM FIELDS=NONE at file level !!

Re: SUM FIELDS=NONE at file level !!

Re: SUM FIELDS=NONE at file level !!

Re: SUM FIELDS=NONE at file level !!

Re: SUM FIELDS=NONE at file level !!

Re: SUM FIELDS=NONE at file level !!