After some private emails, files and job output, Sri noticed that some of the sum fields where too small to host the accumulated values generated by the sort sum statement.
Fixed that and it as expected. Tx to Sri and others that suggested solutions. The original code was in different language translated to rexx. Lesson learned: one byte external decimals (and zone decimal)!should be automatically adjusted to a larger value. ITschak בתאריך יום א׳, 27 באוק׳ 2019, 21:12, מאת Mike Schwab < mike.a.sch...@gmail.com>: > 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 > ---------------------------------------------------------------------- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
