In this blog post, let’s learn about the error message “20853 name is not an SQL/MX object that is supported by FIXUP. Only TABLES and INDEXES are supported.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
20853 name is not an SQL/MX object that is supported by FIXUP. Only TABLES and INDEXES are supported.
Reason for the Error
You attempted to run the FIXUP utility on an SQL/MX object that was not a table or index.
Solution
Do not attempt to run the FIXUP utility on objects other than tables and indexes. Enter a valid name and resubmit