Sum of field

Shriram Jogdand · New User Joined: 14 Oct 2008 Posts: 65 Location: Pune

Hi,

I have file (FB,LREC=80). Values in this file are as below

111,222,333.44-
111,222,333.44
100,222,333.44-
111,111,222.44

Now I want to do summation of these values. When I used sum fields=(1,15,zd), it is giving S0C7 error. Can anybody tell how to achive this in one or 2 steps?

Escapa · Posted: Fri Aug 19, 2011 7:35 pm

Do you want sum to be done based on key field? what is it? where is the position of the key field in the file?

or you want to sum all the numbers to have one line output ?

In what format do you want output number? Is it the same way shown in input?

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

Shriram Jogdand,
Your input is SFF on which you can't directly perform SUM FIELDS . You would need to convert SFF to ZD and then perform SUM accordingly.

Refer to SUM Control Statement for more details on this.

Try something like below...

Shriram Jogdand · New User Joined: 14 Oct 2008 Posts: 65 Location: Pune

Thanks sqlcode1.....

Escapa · Posted: Fri Aug 19, 2011 8:14 pm

This is using OUTFIL SECTIONS....

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

Escapa,
Unless I misunderstood your solution for 92nd position, you could have used TRAILER1 or HEADER1 without SECTIONS. Was this field added for section break.?

Escapa · Posted: Fri Aug 19, 2011 8:32 pm

Skolusu · Posted: Fri Aug 19, 2011 9:58 pm

Shriram Jogdand,

The following DFSORT JCL will give you the desired results. I assumed that you want the output total to be the same format as input