Use SQL_NUMERIC for Result Set Columns of Type SQL_DOUBLE

UseNumeric

Key Name Default Value Required

UseNumeric

Clear (0)

No

Description

When this option is enabled (1), the connector returns data as SQL_NUMERIC data instead of SQL_DOUBLE data.

When this option is disabled (0), the connector returns data as SQL_DOUBLE data.

Note:

This option applies only to result set columns that the connector would normally return as SQL_DOUBLE columns. It does not convert all columns into SQL_NUMERIC.