IBM Mainframe Forum

Can you show the code that you have tried, please. Is that all you want in the output file, just the sum?

Yes..i want output as sum only..
The code i tried as below :

Please use the code tags when posting fixed font stuff like JCL, program code, data. I have coded yor stuff for you. I have also deleted your post that presents the SYSIN only as it simply duplicates the SYSIN data shown above. I seem to recall many posts saying that sort does not know aout decimals. Look them up for possibble solutions.

NicC is correct. Your data is not ZD, because ZD cannot understand "." in the data. There is a table of supported data-types in the manual. Have a look and see if you can get to something. Post back, either if you do or if you are still stuck.

Also, please copy/paste your code from your emulator. Otherwise we end up chasing typos.

ok..i will follow all suggestions.

I am new to the mainframe. I read manual but i am not clear,so can u explain me with sample program,so that it will be helpful for me in future also.

In the DFSORT Application Programming Guide you should find a table called: Summary Field Formats and Lengths. This tells you the data-types you can use for SUM, and points you to a further description of those data-types.

In that further description, you will find a data-type which can describe your data, but which can't be used in SUM.

You will need to convert that value with an actual decimal place into a field-type which SUM can understand, to use SUM.

What is the RECFM and LRECL of your input file? You will need to, temporarily, extend each record, in INREC, and return it to the original size and content, after the SORT and SUM, with OUTREC.

swatmf14 wrote:

Select all

 
e.g
1------------10---------------------------------714---------------723
04/19/2014                                             5600000.00
04/19/2014                                                6000.00
04/14/2014                                             5000000.00

Then i want output in another file as:
Sum   10600000.00

Please help me...

Your summed value is incorrect. It is 10606000.00

If your intention is to sum all the free format values then you need the following control cards



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