In this blog post, let’s learn about the error message “12042 STORE BY PRIMARY KEY is not supported for materialized views.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
12042 STORE BY PRIMARY KEY is not supported for materialized views.
Reason for the Error
You specified the STORE BY clause as PRIMARY KEY in the MV definition.
Solution
Do not specify STORE BY option as PRIMARY KEY, while creating an MV
