Database Error Messages

QSM-02106

mv uses a filter condition in the WHERE or HAVING clause

Cause

The capability in question is not supported when the materialized view includes a filter condition in the WHERE or HAVING clause.


Action

Re-phrase the query to avoid the use of filter conditions in the WHERE or HAVING clauses.