IBM Mainframe Forum

by **ranga_subham** » Mon Oct 13, 2008 11:02 pm

Hi,

I am running a SORT with JOINKEYS and using SUM FIELDS=NONE alon with SORT FIELDS=COPY statement. But the SUM FIELDS=NONE is ignored totally and I am getting duplicates in the output.

Select all

SYSIN :
JOINKEYS FILE=F1,FIELDS=(1,10,A)
JOINKEYS FILE=F2,FIELDS=(26,10,A)
SORT FIELDS=COPY
REFORMAT FIELDS=(F2:26,10)
SUM FIELDS=NONE
WER276B SYSDIAG= 78317, 793906, 793906, 1427692
WER164B 30,808K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 442,336 BYTES USED
WER146B 12K BYTES OF EMERGENCY SPACE ALLOCATED
WER050I SUM CONTROL STATEMENT IGNORED

Would you please tell me how to apply it so that I don't get duplicates into output file.

Thanks.

by **dick scherrer** » Tue Oct 14, 2008 4:37 am

Hello,

You have been doing this long enough that you need to learn to become more self-sufficient. . .

Did you look up the WER050I error message? If not you need to do so and post back here if there is something in the error message info that you do not understand. If your organization is lisensed for Syncsort, all of the material is avaliable from Syncsort (for free).

You might be a beginner, but that is no reason to continue to do so little for yourself (like looking up a message).

d

by **ranga_subham** » Tue Oct 14, 2008 2:29 pm

Hi, Dick.

I definitely understood the WER050I message but I wanted to know how to avoid duplicates because the SUM FIELDS=NONE cannot be used in this scenario.

Thanks.

by **ranga_subham** » Tue Oct 14, 2008 3:16 pm

Ok......now, this is how I achieved it...

Select all

SYSIN :
JOINKEYS FILE=F1,FIELDS=(1,10,A)
JOINKEYS FILE=F2,FIELDS=(26,10,A)
SORT FIELDS=(1,10,CH,A)
SUM FIELDS=NONE
REFORMAT FIELDS=(F2:26,10)

Is it fine?

Thanks.

by **dick scherrer** » Wed Oct 15, 2008 2:37 am

Hello,

Did you run the job?

What happened?

If you post the informational output from Syncsort, we can see what actually happens with this control info. It will be in the SYSOUT output and will probably begin with "SYNCSORT FOR Z/OS".

IBM Mainframe Forum

Why SUM FIELDS=NONE ignored?

Why SUM FIELDS=NONE ignored?

Re: Why SUM FIELDS=NONE ignored?

Re: Why SUM FIELDS=NONE ignored?

Re: Why SUM FIELDS=NONE ignored?

Re: Why SUM FIELDS=NONE ignored?