FloatPrecRadix CLI/ODBC configuration keyword

db2cli.ini keyword syntax:

FloatPrecRadix = 2 | 10

Default setting:

Report the NUM_PREC_RADIX as 2 for floating point types, as they have a base of 2, not 10.

Usage notes:

 

The NUM_PREC_RADIX value represents a data type's base. Binary numbers, such as floating point numbers, have a base of 2, and integers have a base of 10. An application may expect all values in the COLUMN_SIZE field to represent the maximum number of digits, which assumes a NUM_PREC_RADIX value of 10. However, for floating point numeric types, the NUM_PREC_RADIX is 2, in which case the COLUMN_SIZE will report the number of bits in the data type's representation, rather than the maximum number of digits.

FloatPrecRadix can force the NUM_PREC_RADIX to be reported as 10 for floating point data types, in which case the COLUMN_SIZE will report the maximum number of digits.

The FloatPrecRadix keyword affects SQLColumns(), SQLGetDescField() (for the SQL_DESC_NUM_PREC_RADIX field), SQLGetTypeInfo(), SQLProcedureColumns(), and SQLSpecialColumns().