IfxDecimal structure

An IfxDecimal object represents a decimal number with up to 32 significant digits. The range of valid values is from 10^-129 to 10¹²⁹.

The DECIMAL data type in HCL OneDB™ databases can represent a larger range of values than will fit in any of the .NET Framework data types. It can also be a floating point number rather than a fixed point number. This is why you should use an IfxDecimal object to store values that are stored on the database as a DECIMAL or its equivalent.

You can use IfxDecimal to preserving numerical value, but not for preserving the scale. For example, a value 100 can be displayed as 100.0. Similarly, 100.00 can be displayed as 100.0. IfxDecimal always stores a floating point value. To preserve scale, use Decimal instead of IfxDecimal.