DB2 FLOAT and REAL datatypes have approximately the same precision but different ranges from the corresponding Open Client and Open Server types. Values that are valid in Open Client and Open Server may be out of range for DB2. Table 4-3 shows the approximate ranges for DB2 FLOAT and REAL datatypes, and Open Client and Open Server CS_FLOAT and CS_REAL datatypes.
DB2 datatype |
Approximate range |
Open Client and Open Server datatype |
Approximate range |
|---|---|---|---|
FLOAT |
-7.2E75 to +7.2E75 |
CS_FLOAT |
-1.7977E308 to +1.7977E308 |
REAL |
-7.2E75 to +7.2E75 |
CS_REAL |
-3.4028E38 to +3.4028E38 |
