You're right of course. I could have figured it out myself by going step-by-step with a selected subset of the real data and pieces of the SORT control cards to get the process right first.
As for your last two sets of questions, I'm not at liberty to say. Peter -----Original Message----- From: IBM Mainframe Discussion List [mailto:[email protected]] On Behalf Of Bill Woodger Sent: Monday, October 24, 2016 2:39 PM To: [email protected] Subject: Re: SYNCSORT SUM of duplicates - What am I doing wrong please? Then there's the question of "testing". If attempting this on 14m records, it will SORT them all before the SUM fails (and you may have got unlucky with the previous values in the "filler"). To see what the OVERLAY was doing, take out the SORT and the SUM and run on a test file (even the full file, with OPTION STOPAFT=10 or the like). When getting used to SORT Control Cards, I'd do add a bit at a time. When looking for problems, take a bit off at a time. Either way you get to "see" what you have said should happen to the data. 219 bytes for the key? 14m+ records? 11-digit number for duplicate keys? What is the significance of the duplicate keys? Is the data not already in that sequence at some point (else there would seem to be little significance)? -- This message and any attachments are intended only for the use of the addressee and may contain information that is privileged and confidential. If the reader of the message is not the intended recipient or an authorized representative of the intended recipient, you are hereby notified that any dissemination of this communication is strictly prohibited. If you have received this communication in error, please notify us immediately by e-mail and delete the message and any attachments from your system. ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
