DB2 Version 9.7 for Linux, UNIX, and Windows

MapDecimalFloatDescribe CLI/ODBC configuration keyword

Specifies the default C type and reported data type of DECFLOAT columns and parameter markers.

db2cli.ini keyword syntax:

MapDecimalFloatDescribe = 0 | 1| 2| 3

Default setting:

Usage notes:

MapDecimalFloatDescribe controls the default C type to be used for columns and parameters with a data type of DECFLOAT. It affects the behavior of CLI functions for which SQL_C_DEFAULT can be specified as the C type of a column or parameter. Examples of such functions include SQLBindParameter(), SQLBindCol(), and SQLGetData().

MapDecimalFloatDescribe also controls the type that will be reported for columns and parameters that have a data type of DECFLOAT. This affects CLI functions that return information about parameters and columns. Examples of such functions include SQLColAttribute() and SQLDescribeParam().

Use this configuration keyword for applications that cannot handle decimal float types or when you would rather always deal with decimal float types as some other type.

Here are the allowed values:

Table 1. Valid values for MapDecimalFloatDescribe
Value	DECFLOAT columns and parameters are reported as being this type	DECFLOAT columns and parameters use this default C type
0	SQL_DECFLOAT	SQL_C_CHAR
1	SQL_VARCHAR	SQL_C_CHAR
2	SQL_WVARCHAR	SQL_C_WCHAR
3	SQL_DOUBLE	SQL_C_DOUBLE