In this blog post, let’s learn about the error message “21053 Indexes source-index and target-index have incompatible index specifications.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
21053 Indexes source-index and target-index have incompatible index specifications.
Reason for the Error
The FASTCOPY INDEX command is executed. The index specifications for the source and target tables do not satisfy all the following conditions:
indexes have the same number of index columns
each source-target pair of index columns, in key sequence order, have the same column number in the tables
Solution
None