Sri, This was just an example. I am trying to summarize by sort keys. there might be ten records with same sort keys. I expect a single record in output file (such as DUPKEYS SUM in syncsort). However, the result is that I get several records with same keys in the output.
More specific: OPTION EQUALS SORT FIELDS=(6,5,ch,a,53,3,ch,a) sum fields=(245,15,ZD,123,11,ZD) As the are about 15 records with same sort keys I want to summarize all into a single record. Is this possible, or should I write my own program? ITschak On Sun, Oct 27, 2019 at 1:53 PM Sri h Kolusu <[email protected]> wrote: > >>>sum flelds =(3,4,zd,5,6,zd). > > ITschak, > > I am pretty sure that would result in overlapping error as your summing > field at position 3 for 4 bytes extend up to position 6, but your second > sum field starts at position 5 which overlaps the first sum field. You > should be getting an ICE125A message. > > >>I would expect to have a single record in the output. however, I get two. > what am i missing? > > If the overlapping fields was a typo, and if you say that you are getting 2 > records, then I am guessing that there is an OVERFLOW during summing and > you would see an ICE152I message. Check if your joblog has any such > message. You can override the return code 0 during overflow by adding the > following statement to your control card statement. > > OPTION OVFLO=RC4 > > > Thanks, > Kolusu > DFSORT Development > IBM Corporation > > ---------------------------------------------------------------------- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to [email protected] with the message: INFO IBM-MAIN > -- ITschak Mugzach *|** IronSphere Platform* *|* *Information Security Contiguous Monitoring for Legacy **| * ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to [email protected] with the message: INFO IBM-MAIN
