How does SUM FIELDS = NONE work?
-
Sum up value in the fields specified in the SORT FIELDS statement and keep it as only one occurence in the o/p
-
Removes the duplicates for the fields specified in the SORT FIELDS statement and keeps only the 1st occurence of it
-
Works only for those records in the i/p file where no duplicates for the fields specified in SORT FIELDS statement,
-
None of the above
SUM FIELDS = NONE removes duplicates by keeping only the first occurrence of records with matching sort keys. Despite the name 'SUM', it doesn't perform arithmetic summation when =NONE is specified - it deduplicates. The matching fields are those in SORT FIELDS statement.
In sort utilities like SyncSort/DFSORT, SUM FIELDS=NONE tells the sort to treat the SORT FIELDS as the key for duplicate detection and to discard all but the first record for each distinct key value — it does not perform any numeric summation despite the SUM keyword. This differs from SUM FIELDS=(...) which would actually add up numeric fields across duplicate-key records. The other options either describe summation behavior or restrict it to files with no duplicates, which isn't how the NONE keyword works.