SUM FIELDS=NONE at file level



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

SUM FIELDS=NONE at file level

Postby ranga_subham » Wed Jul 04, 2012 3:42 pm

Hi,

Request you to explain me on how to apply SUM FIELDS=NONE at file level (SORTOF1,SORTOF2.........SORTOF9).

Please help.

Thanks.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: SUM FIELDS=NONE at file level

 

Re: SUM FIELDS=NONE at file level !!

Postby NicC » Wed Jul 04, 2012 6:36 pm

No idea what you mean - please show an example
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: SUM FIELDS=NONE at file level !!

Postby ranga_subham » Wed Jul 04, 2012 7:14 pm


//STEP0001 EXEC PGM=SORT  
//SORTIN   DD *          
A3                        
A1                        
A2                        
//SORTOUT  DD SYSOUT=*    
//SYSOUT   DD SYSOUT=*    
//SYSIN    DD *          
 SORT FIELDS=(1,2,CH,A)  
 SUM FIELDS=NONE          
//*                      
 


How to apply "SUM FIELDS=NONE" at file level?

Thanks.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: SUM FIELDS=NONE at file level !!

Postby BillyBoyo » Wed Jul 04, 2012 7:31 pm

No, that still isn't clear.

You are showing a SUM FIELDS=NONE at the "file level". Across the file duplicates are dropped based on the value of the first two bytes of each record.

Try to tell us exactly what you are trying to achieve, please.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: SUM FIELDS=NONE at file level !!

Postby dick scherrer » Thu Jul 05, 2012 8:46 am

Hello,

You need to post some data that represents what you want to do. The data posted is of no use as is. You also need to post the output you want from the sample input data.

Why did you mention (SORTOF1,SORTOF2.........SORTOF9)? These are not in the jcl.
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

Re: SUM FIELDS=NONE at file level !!

Postby ranga_subham » Fri Jul 06, 2012 7:47 pm

Hi,

Let me try to explain my requiremnt with a different example:


//STEP0001 EXEC PGM=SORT
//SORTIN   DD *
A1 B1
A2 B2
A1 B3
A2 B1
//SORTOUT  DD SYSOUT=*
//SYSIN    DD *
 SORT FIELDS=(1,2,CH,A)
 SUM FIELDS=NONE
/*
 


The above SORT gives me below output:


A1 B1
A2 B1
 


And, if I use below shown SORT card --->


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


I will get below shown output --->


A2 B1
A2 B2
A1 B3
 


How to get first output into SORTOF1 and second output into SORTOF2 using single SORT step? Is it possible to apply SUM FIELDS=NONE on SORTOF1 and SORTOF2 individually instead of job level?

I hope I have explained it in a better way.... :roll:

Thanks.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: SUM FIELDS=NONE at file level !!

Postby dick scherrer » Fri Jul 06, 2012 8:43 pm

Hello,

Yes, you have explained this more clearly.

No, you cannot do what you want in a single step as far as i know.
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

Re: SUM FIELDS=NONE at file level !!

Postby Ed Goodman » Fri Jul 06, 2012 11:09 pm

You SEEM to trying to get all types of "A" in one file, then all types of "B" in the other file. If that's true, then you'll have to do multiple passes.

You can reduce SOME of the I/O by doing the first sum as all unique combinations of the two: FIELDS=(1,5,CH,A), then FIELDS=NONE. That will give you a file with every possible combination listed only once. That will probably be a lot smaller than the original file.

Then take that smaller file and do two steps, one for FIELDS=(1,2) and one for FIELDS=(4,2). Each of them would have all of the values that appear.
Ed Goodman
 
Posts: 342
Joined: Thu Feb 24, 2011 12:05 am
Has thanked: 3 times
Been thanked: 17 times

Re: SUM FIELDS=NONE at file level !!

Postby Thampy » Sat Jul 07, 2012 5:01 am

PipeSort (SyncSort’s Value-Added Products) enables SyncSort to run multiple sorts simultaneously on the same input data.
For large input files, PipeSort significantly reduces total elapsed time compared to running separate sort jobs

PipeSort reads SORTIN once and distributes the input records to up to eight simultaneous SyncSort executions. The complete range of SyncSort control statements and PARMs is available for the individual sort operations.
The output files are differently sequenced according to user-specified sort keys and are written to different SRTnOUT DD data sets.

Sample JCL

//STEP030  EXEC PGM=PIPESORT                                  
//SYSOUT    DD SYSOUT=*                                        
//SYSOUT1   DD SYSOUT=*                                        
//SYSOUT2   DD SYSOUT=*                                        
//SORTIN    DD DSN=Your.Input.File,DISP=SHR    
//SRT1OUT   DD DSN=Output.File1,              
//             DISP=(,CATLG),SPACE=(CYL,(50,50),RLSE),        
//             DCB=(RECFM=FB,LRECL=28,DSORG=PS)                
//SRT2OUT   DD DSN=Output.File2,                  
//            DISP=(,CATLG),SPACE=(TRK,(5,1),RLSE),            
//            DCB=(RECFM=FB,LRECL=13,BLKSIZE=27989)            
//SRT1CNTL   DD *                                              
 SORT FIELDS=(5,6,CH,A,1,4,CH,A)
SUM FIELDS=NONE                              
//*                                                            
//SRT2CNTL   DD *                                              
 SORT FIELDS=(1,13,CH,A)                                      
 INCLUDE COND=(7,1,CH,EQ,C'2')                                
 OUTREC FIELDS=(1,13)                
 SUM FIELDS=NONE            
//*                          

Note : If PIPESORT is not licensed for your shop,then you will get a WER903I message

These users thanked the author Thampy for the post:
tivrfoa (Wed Jan 16, 2013 11:55 pm)
Thampy
 
Posts: 35
Joined: Sat Sep 26, 2009 2:27 pm
Has thanked: 0 time
Been thanked: 3 times

Re: SUM FIELDS=NONE at file level !!

Postby ranga_subham » Sun Jul 08, 2012 8:57 am

Thampy, thanks a lot.......I ran PIPESORT but don't get expected results !!

SRT2OUT did not show up and my SRT1OUT shows below info:
A1 B1 
A2 B1 
A2 B2 
A1 B3 


Thanks.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Next

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post