You'll need z/OS DFSORT V1R5 PTF UQ95214 or DFSORT R14 PTF UQ95213 (Dec, 2004) in order to use DFSORT's SFF format. Only DFSORT has this function, so if you don't have DFSORT, you won't be able to use it. If you do have DFSORT, but you don't have the Dec, 2004 PTF, ask your System Programmer to install it (it's free). For complete details on all of the new DFSORT and ICETOOL functions available with the Dec, 2004 PTF, see:
With DFSORT, you can use SORT, SECTIONS, TRAILER3 and TOTAL with SFF to do the equivalent directly, or you can convert the numbers with signs and decimal point to another format that you can use in SUM (such as ZD). If you want me to show you how to do one or the other, please show an example of your input records and what you want the output records to look like. Give the starting position, length and format of the relevent fields, and the RECFM and LRECL of the input file. The more specific example you give, the more specific solution I can give.
Well my layout is of 245 bytes.Of which I want to sum on customer numbers which is pos 1 to pos7.The sum I want is of quantity (219 to 224) and dollars 225 to 236.
I would have loved to use
But since both quantity and dollars are character fields, I cant do that.
So I would like to copy the entire rec to same file layout,just those two fields will not be character but ZD.
Then onwards I can proceed with the SORT and SUM thing.
Let me know how can I do that.
You can use DFSORT's SFF format to convert most types of data containing digits as well as signs, decimal points, separators, etc to ZD format. So you can probably do what you asked for with DFSORT like this: