Re: Informix Error Message

mars1972@my-deja.com wrote: >I've seen this happen, but not on Online. When I got it, it was because >I had a record in a money field that was stored something like 5.96e27, >or 5.96 times 10 to the 27th power. > >The way I found it was I unloaded all the records for the day in >question and scanned the file manually until I found the bad record. >Then I updated it using it's primary key. If that were the problem here wouldn't the sum for the 17th fail? My assumption being that if 1-16 works and 1-17 fails that the problem would be in the 17th data. But if that were the case, the sum of the values on the 17th would fail when it hits that row. Right? >In article <8f6puj$fe6$1@nnrp1.deja.com>, > guinep@my-deja.com wrote: >> Hi, >> >> I am using Informix Dynamic Server 7.2. The database error -1226 >> "Decimal or money value exceeds maximum precision" is generated when >an >> SQL query of the following type is executed: >> >> select sum(....) + sum(....) >> from table1, table2 >> where <join condition> >> and <column> between date1 and date2 >> >> The maximum value that could be calulated does NOT exceed the >> maximum precision. Furthermore, attempts to sum the data for say, >> January 1 thru January 16, succeed, but the sum for January 1 thru >> January 17 fails. The sum for January 17 succeeds. >> >> Could the table be corrupted? >> >> If anyone could help with this problem, I would be very grateful. >Please >> email guinep@my-deja.com. >> >> Sent via Deja.com http://www.deja.com/ >> Before you buy. >> > >-- ># unrm / >ksh: unrm: not found ># man cpio > > >Sent via Deja.com http://www.deja.com/ >Before you buy. carlos Currently on hiatus from unemployment. ---------------------- Do you do Linux? :) Get your FREE @linuxstart.com email address at: http://www.linuxstart.com