Duplicate removal and sum



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Re: Duplicate removal and sum

Postby storage » Tue Dec 22, 2009 10:46 am

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..
storage
 
Posts: 28
Joined: Tue Nov 11, 2008 3:48 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Re: Duplicate removal and sum

 

Re: Duplicate removal and sum

Postby storage » Tue Dec 22, 2009 3:29 pm

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.
storage
 
Posts: 28
Joined: Tue Nov 11, 2008 3:48 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Duplicate removal and sum

Postby Frank Yaeger » Tue Dec 22, 2009 9:01 pm

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.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post