SORT card to add the field values

puneetvirmani143 · New User Joined: 24 Jul 2007 Posts: 55 Location: noida

Hi All,
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 ?

Thanks
Puneet

CICS Guy · Posted: Tue Feb 19, 2008 8:10 pm

Have you looked int UFF & SFF?

CICS Guy · Posted: Tue Feb 19, 2008 9:26 pm

puneetvirmani143 · New User Joined: 24 Jul 2007 Posts: 55 Location: noida

Hi,
Below is the code I am using for my requirement but I am getting user abend S000 U0016 and message is INVALID INREC OR OUTREC STATEMENT OPERAND.

William Thompson · Posted: Tue Feb 19, 2008 9:36 pm

How about providing the actual sysout containing the error?

Frank Yaeger · Posted: Tue Feb 19, 2008 10:26 pm

puneetvirmani143,

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.