🎴 Flashcard Mode
Mainframe Technologies: JCL, COBOL, VSAM and DB2
Card1 / 20
Mastered0
Review0
QuestionClick to flip
What is the use of SUM FIELDS=NONE in SORT statement
AnswerClick to flip back
A
(B) Remove Duplicates records and write as single instance in output
💡 Explanation:
SUM FIELDS=NONE in JCL/SORT eliminates duplicate records by keeping only one instance when multiple records have matching sort keys. Unlike SUM FIELDS with numeric fields (which sums values), FIELDS=NONE simply discards duplicates, yielding unique records.