Page 2 of 2

Re: Duplicate removal and sum

PostPosted: Tue Dec 22, 2009 10:46 am
by storage
Hello,
LRECL=80
RECFM=FB
I have a huge list which to be added..and the sum fields can vary from 11-19 and 22-29..
I hope it makes sense now..

Re: Duplicate removal and sum

PostPosted: Tue Dec 22, 2009 3:29 pm
by storage
Hello,
LRECL=80
RECFM=FB
There is a lot of data which is to be added and the position for addition varies from 11-19 and 22-29.

Re: Duplicate removal and sum

PostPosted: Tue Dec 22, 2009 9:01 pm
by Frank Yaeger
If you have ZD fields to be summed in 11-19 and 22-29, the DFSORT control statements would be:

  OPTION ZDPRINT
  SORT FIELDS=(1,3,CH,A)
  SUM FIELDS=(11,9,ZD,22,8,ZD)


If you get an S0C7, then you either have the wrong positions or invalid ZD values.