use an inrec statement to enlarge numeric fields so you don't exceed the size of the field.
On Sun, Oct 27, 2019 at 7:08 AM ITschak Mugzach <imugz...@gmail.com> wrote: > > 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 <skol...@us.ibm.com> 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 lists...@listserv.ua.edu 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 lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- Mike A Schwab, Springfield IL USA Where do Forest Rangers go to get away from it all? ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
