Approximate numeric data types (FLOAT, DOUBLE, and REAL) are SQL data types that enable floating points.
Host Variable Formats
- OpenESQL and DB2 ECM
-
01 real1 USAGE COMP-1.
01 float1 USAGE COMP-2.
- The
real1 format is for the 32-bit (single-precision) SQL floating-point data type, REAL.
- The
float1 format is for 64-bit (double-precision) SQL floating-point data types, FLOAT and DOUBLE.
- OpenESQL JVM Managed Runtime
- In addition to the definitions valid for OpenESQL, the following definition is also valid for the OpenESQL JVM Managed Runtime:
01 real2 float-short.
01 float2 float-long.
