problem with sum() aggregate on IDS 7.30

Help!! I work with IDS 7.30 on SCO 5.0.5. When I try to calculate the sum() over a decimal or money column, the SUM() aggregate breaks with error 1226 (DECIMAL or MONEY value exceeds maximum precision ) when the result takes more place than one byte over column definition. For example when the column is defined decimal(3,0), the maximum possible result is 9999. This is true for 4GL and SQL. This problem never happened with my old SE 4.1 Has anyone experience with this problem? please help me! Thomas Bartsch

> When I try to calculate the sum() over a decimal or money column, > the SUM() aggregate breaks with error 1226 (DECIMAL or MONEY value exceeds This is the known bug of IDS 7.30.xx, ask Informix for update. I don't known about SCO, but for NT this is patched in version 7.30.TC7 If you are in hurry then change decimal (money) fields to new, bigger range. For example from decimal(5,2) to decimal(10,2) - application (sum) dependent. Leos