In this blog post, let’s learn about the error message “20417 Column name1 in model-table-name is incompatible with column name2 in target-table-name: reason is different.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20417 Column name1 in model-table-name is incompatible with column name2 in target-table-name: reason is different.
Reason for the Error
The model table for MODIFY REPARTITION has a column that differs from the corresponding column in the target table.
Solution
Specify a model table where each column matches its counterpart in the target table on all important aspects
