In this blog post, let’s learn about the error message “12323 Creation failed. The selection predicate includes a non-repeatable expression. Incremental refresh type cannot be specified.” when working with HPE NonStop SQL/MX, the reason for the error and the solution to fix this error message.
Error Message
12323 Creation failed. The selection predicate includes a non-repeatable expression. Incremental refresh type cannot be specified.
Reason for the Error
You attempted to specify a non repeatable expression in the materialized view definition.
Solution
Remove the non repeatable expression from the materialized view definition and resubmit the statement
