I am having a Input File. Can I write a SORT statement to calculate what is the total value of "Net Value" and "Billing Quantity" fields for month of Jan, Feb and March in the input file ?
Month fields start from 18th position and is of length 2 ."NetValue" field: starts at 84th position and total of length 9 (6 digits ,then a "." and then 2 digits ) ."Billing Quantity" starts start at position 93 and is of length 9.
As per my knowledge SORT statement don't recognize a "." . So I think we have to add the 6 decimal separately in one SORT step and 2 digits (after decimal) in another SORT step. Then add both of them manually to reach at the final figure.
Can anybody tell me the exact syntax for Sort card to add the field values ?
The fact that you got the ICE104A message for those control statements indicates you do not have z/OS DFSORT V1R5 PTF UQ95213 or DFSORT R14 PTF UQ95213. That PTF has been available since Dec, 2004 so your site is way behind in DFSORT service. The control statements work fine with that PTF (except that you should have 93,9,ZD instead of 93,12,ZD in the SUM statement).
Ask your System Programmer to install z/OS DFSORT V1R5 PTF UK90007 or DFSORT R14 PTF UK90006 (April, 2006). That will get you all of the latest DFSORT function.