Doubt in Sum fields - finding sum of a field

[thamodharan]

Hi,

I have a requirement to sum a field irrespective of any fields in the PS file.

Input file,

100 ttt aaa
200 xxx yyy
300 aaa xxx
100 yyy tttt

output must be,

700 ....

When i use the following, I am not getting the desired output. Because it summing with respect to a specific field.

Sort fields=(5,3,ch,a)
sum fields=(1,3,zd)

Please suggest me a sort card for this requirement.

TIA.

Regards,
Thamu

[Frank Yaeger]

I don't know what the ... after the 700 represents, but if you just want to add a trailer record with the total of the first field, you can use these DFSORT control statements:

Code: Select all

   OPTION COPY                                 
   OUTFIL REMOVECC,                            
      TRAILER1=(TOT=(1,3,ZD,TO=ZD,LENGTH=3))   

SORTOUT would have:

Code: Select all

100 ttt aaa       
200 xxx yyy       
300 aaa xxx       
100 yyy tttt      
700               

If you want something else for output, show exactly what you want.

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

http://www.ibm.com/support/docview.wss? ... g3T7000080

[thamodharan]

Hi Frank,

I wanted only SUM in the output and it works fine.

Thanks for the help as well as the online tutorial.

Regards,
Thamo