|
View previous topic :: View next topic
|
| Author |
Message |
pahi
Currently Banned
New User
Joined: 04 Dec 2008
Posts: 7
Location: bangalore
|
|
|
|
Hi,
I have sort fields then if i give sum fields=none then those fields which are repeated wont de displayed. but if i give sum fields=(22,6,pd,28,2,pd) what does it means? |
|
| Back to top |
|
 |
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales
|
|
|
|
| Have you bothered to look in the manual |
|
| Back to top |
|
|
pahi
Currently Banned
New User
Joined: 04 Dec 2008
Posts: 7
Location: bangalore
|
|
|
|
| Ya i have looked into the manual but i couldn't found much about sum fields, so can you tell where to search exactly? |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Hi,
Expat has given you the right direction:
| Quote: |
| The SUM control statement deletes records with equal control fields and optionally summarizes specified numeric fields on those records. Equal keyed records are processed pair by pair. If numeric fields are to be summarized, the data in the summary fields are added, the sum is placed in one of the records, and the other record is deleted. Provided arithmetic overflow does not occur, the SUM control statement produces only one record per sort key in the output data set. The records deleted by sum can optionally be written to a separate dataset. |
Usually, I remember it as "Set Under Mask". |
|
| Back to top |
|
|
pahi
Currently Banned
New User
Joined: 04 Dec 2008
Posts: 7
Location: bangalore
|
|
|
|
Thank you  |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
|
|
