-20166 AN SQL DATA CHANGE STATEMENT WITHIN A SELECT SPECIFIED A VIEW view-name WHICH IS NOT A SYMMETRIC VIEW OR COULD NOT HAVE BEEN DEFINED AS A SYMMETRIC VIEW

Explanation

The target view of the SQL data change statement within a SELECT statement must be defined WITH CASCADED CHECK OPTION, or the fullselect in the view definition (or the fullselect of a view definition of a referenced view) must be able to be defined using WITH CASCADED CHECK OPTION.

A symmetric view is a view defined implicitly or explicitly with the WITH CASCADED CHECK OPTION.

System action

The statement cannot be processed.

Programmer response

Do not use the SQL data change statement within a SELECT with the specified view.

SQLSTATE

428FM