In this blog post, let’s learn about the error message “20411 Table table-name is not empty.table-nameis the fully qualified ANSI name of the model table.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20411 Table table-name is not empty.table-nameis the fully qualified ANSI name of the model table.
Reason for the Error
The model table for MODIFY TABLE … REPARTITION is not empty.
Solution
Specify an empty model table in the MODIFY TABLE … REPARTITION command text
