Why SUM FIELDS=NONE ignored?



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Why SUM FIELDS=NONE ignored?

Postby 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.

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.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Why SUM FIELDS=NONE ignored?

 

Re: Why SUM FIELDS=NONE ignored?

Postby 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
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Why SUM FIELDS=NONE ignored?

Postby 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.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Why SUM FIELDS=NONE ignored?

Postby ranga_subham » Tue Oct 14, 2008 3:16 pm

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

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.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: Why SUM FIELDS=NONE ignored?

Postby 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".
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post