KFAA72005-W
Data was truncated when a data type was converted in the ODBC driver. (ColumnNumber = aaaa, SQLSTATE = bb....bb, SQL DataType = cc....cc, SQL_C_DataType = dd....dd, reason = ee....ee) (O)
Data was truncated in data type conversion processing performed by the ODBC driver. <SQLSTATE: 01004, 01S07>
- aaaa:
-
Number of the column where data was truncated
- bb....bb:
-
Value of SQLSTATE
- cc....cc:
-
ODBC SQL data type where data was truncated
- dd....dd:
-
C data type where data was truncated
- ee....ee:
-
Reason why data was truncated
- S:
-
Terminates processing.
- Action:
-
The following table lists the possible reasons for truncation that are displayed in place of ee....ee and the corrective action to take.
Item No.
Content displayed for ee....ee
Reason for the truncation and corrective action to take
1
The column for values other than character data was truncated
A character string was truncated because the conversion-target area was too small.
Specify a sufficiently large conversion-target area, and then retry the operation.
2
The column for values other than data decimal numbers was truncated or fractions were omitted
Data not allowed by the fractional seconds specification or data following the decimal point, for example, was truncated because the conversion-target area was too small or because the setting status of the attribute value does not allow the data.
-
If floating-point type data was converted to integer values, for example, data following the decimal point was truncated.
-
For other conversions, specify a sufficiently large conversion-target area, and then retry the operation.
If the data type of the value to be saved as the conversion-target data is SQL_C_NUMERIC, use SQLSetDescField to specify SQL_DESC_PRECISION and SQL_DESC_SCALE, set a sufficient number of places following the decimal point, and then retry the operation by using SQLBindCol and SQLFetch. Scale values that indicate the number of places following the decimal point cannot be changed by using SQLGetData.
3
multiple reasons
Warning for other reason. Check the value of SQLSTATE.
-