I am working very old 4gl codebase. The way code is handle decimal datatype is raising question..
For example if we have table column with decimal(8,3) the max value it could is 7 digit and 1 dot character.
So what to know if old informix version has any such limition. Do older version of DB has this limition. AS with version 11 we could hold 8 digit and 1 dot character. (99999.999)
When we declare a column of decimal data type with a precision (3,1), the max field length which INFORMIX allows is 4 (including period), 1 digit on right of period and 2 digits on left of period.
In earlier versions of INFORMIX (pre 7) , the period was included in total field length which means if we declare a column of decimal type with a precision (3,1), the max field length which INFORMIX allows is 3 (including period), 1 digit on right of period and 1 digits on left of period.
Decimal declaration Earlier version (max) newer version IDS(max)
decimal (3,1) 1.2 12.3
Remarks : Earlier version may used to include "period" in total length and post 7 excludes “period” from total length.