logo  
Google
 

DB2 SQL-Error: -20166

SQLState: 428FM

Short Description: INSERT STATEMENT WITHIN A SELECT SPECIFIED A VIEW WHICH IS NOT A SYMMETRIC VIEW

The target view of the INSERT statement within a SELECT statement must be defined WITH CASCADED CHECK OPTION or the fullselect in the view definition must not have a WHERE clause. A symmetric view is a view defined implicitly or explicitly with the WITH CASCADED CHECK OPTION. System action: The statement cannot be executed Programmer response: Do not use the INSERT statement within a SELECT with the specified view.

 <-  BACK TO INDEX