In this blog post, let’s learn about the error message “12113 ON STATEMENT MAVs and MAJVs are currently not supported.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
12113 ON STATEMENT MAVs and MAJVs are currently not supported.
Reason for the Error
The materialized view definition contains an aggregate expression or function or a group by clause with or without joining two or more tables.
Solution
Use equi-join only with ON STATEMENT materialized views
