Hitachi

Hitachi Advanced Database Messages


KFAA72004-E

A data conversion error occurred in the ODBC driver. (ColumnNumber = aaaa, SQLSTATE = bb....bb, SQL DataType = cc....cc, SQL_C_DataType = dd....dd, reason = ee....ee) (O)

An error occurred in data type conversion processing performed by the ODBC driver. <SQLSTATE: 07006, 22003, 22007, 22018, 5C002, 5C037, 5C038, HY001, HY003, HY004, HY009, HY013, HY090, HY104, HYC00>

aaaa:

Number of the column in which the error occurred

bb....bb:

Value of SQLSTATE

cc....cc:

ODBC SQL data type whose conversion failed

dd....dd:

C data type whose conversion failed

ee....ee:

Cause of the error

S:

Terminates processing.

Action:

Check the following and take corrective action, as necessary:

  • SQLSTATE value displayed in place of bb....bb

  • Data type conversion combination

  • Cause of the error displayed in place of ee....ee

    The following table lists the possible causes of the error that are displayed in place of ee....ee and the corrective action to take.

    Item No.

    Content displayed for ee....ee

    Cause of the error and corrective action to take

    1

    conversions are not supported

    The combination of data types that was specified cannot be converted. Change the combination of data types specified to a combination of data types that can be converted. For details about the combinations of data types that can be converted, see Combinations of data types that can be retrieved (conversion from ODBC's SQL data types to C data types), under Correspondence between ODBC's SQL data types and C data types, in the HADB Application Development Guide.

    2

    value outside the scope of the conversion destination data type

    The value is outside the range for the data type into which the value will be converted. Change the data type into which the value will be converted to something larger.

    3

    data type cannot be converted

    The data format cannot be converted. Specify a different data type, or re-enter the data in the correct data format.

    4

    multiple reasons

    One of the following errors has occurred:

    • The value is outside the range for the data type into which the value will be converted.

    • The data format cannot be converted.

    Take the corrective action for item 2 or item 3, or check the value of SQLSTATE.