The floating-point data types

The database server supports the following data types for floating-point values.
SQL floating-point data type ESQL/C or C language type Range of values
SMALLFLOAT, REAL float Single-precision values with up to 9 significant digits
FLOAT, DOUBLE PRECISION double Double-precision values with up to 17 significant digits
DECIMAL(p) decimal Absolute value range 10-130 - 10124