In this blog post, let’s learn about the error message “20206 Data type conversion failed while converting key value (column-value[, column-value]…)to data type(s) ( data-type[,date-type]…) for object-name.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20206 Data type conversion failed while converting key value (column-value[, column-value]…)to data type(s) ( data-type[,date-type]…) for object-name.
Reason for the Error
You specified a key column value whose data type was incompatible with the data type of the corresponding partition key column.
Solution
None