KFAA72006-E
A data conversion error occurred in the ODBC driver. (ParameterNumber = aaaa, SQLSTATE = bb....bb, SQL_C_DataType = cc....cc, SQL DataType = dd....dd, reason = ee....ee) (O)
An error occurred in data type conversion processing performed by the ODBC driver. <SQLSTATE: 07006, 22001, 22003, 22007, 22008, 22018, 5C002, 5C036, HY001, HY003, HY004, HY009, HY013, HY090, HY104, HYC00>
- aaaa:
-
Sequence number of the dynamic parameter in which the error occurred
- bb....bb:
-
Value of SQLSTATE
- cc....cc:
-
C data type whose conversion failed
- dd....dd:
-
ODBC SQL 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 for bb....bb
-
Data type conversion combination
-
Cause of the error displayed for 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 compared and stored or assigned (conversion from C data types to ODBC's SQL 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 input value is outside the range for the data type into which the value will be converted. Change the input value to something in the range for the data type into which the value will be converted.
3
insufficient memory
Memory is insufficient. Retry the operation after shutting down another application.
4
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.
5
multiple reasons
One of the following errors has occurred:
-
The input 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 4, or check the value of SQLSTATE.
6
data for the parameter was not bound
The data for a dynamic parameter was not bound. Either bind the input parameter area for the dynamic parameter with SQLBindParameter, or specify it with SQLPutData.
7
String data, right-truncated
The character string or binary data was truncated on its right end. Change the input value to be in the range for the data it will be converted into.
-
-