-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