In this blog post, let’s learn about the error message “20224 This table cannot be purged because at least one of the referencing tables is not empty.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20224 This table cannot be purged because at least one of the referencing tables is not empty.
Reason for the Error
You attempted to purge data from a table that is being referenced by at least one non-empty table through referential integrity constraint.
Solution
Remove the referential integrity constraint and resubmit