In this blog post, let’s learn about the error message “20420 Index index-name reason be UNIQUE.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20420 Index index-name reason be UNIQUE.
Reason for the Error
The model index for a MODIFY INDEX … REPARTITION is unique and the target index is non-unique or conversely.
Solution
Specify a model index with the same uniqueness as the target index