HPE NonStop SQL/MX Error – 20125 table name is a metadata table. PURGEDATA cannot be performed on metadata tables.

In this blog post, let’s learn about the error message “20125 table name is a metadata table. PURGEDATA cannot be performed on metadata tables.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.

Error Message

20125 table name is a metadata table. PURGEDATA cannot be performed on metadata tables.

Reason for the Error

The table name that you specified was a metadata table. You cannot perform the PURGEDATA operation on metadata tables.

Solution

Specify a different table and resubmit