In this blog post, let’s learn about the error message “12052 The specified attribute is not supported for ALTER MATERIALIZED VIEW.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
12052 The specified attribute is not supported for ALTER MATERIALIZED VIEW.
Reason for the Error
ALTER MATERIALIZED VIEW command attempted an unsupported attribute change.
Solution
Currently, ALTER MATERIALIZED VIEW command supports only ANSI RENAME option