-161   THE INSERT OR UPDATE IS NOT ALLOWED BECAUSE A RESULTING ROW DOES NOT SATISFY THE VIEW DEFINITION

Explanation

The WITH CHECK OPTION applies to the view that is the object of the insert or update operation. Consequently, all attempts to insert or update rows in that view are checked to ensure that the results will conform to the view definition.

System action

The statement cannot be processed. No inserts or updates were performed, and the contents of the object view (and underlying base table) remain unchanged.

Programmer response

Examine the view definition to determine why the requested insert or update operation was rejected. Note that this may be a data-dependent condition.

SQLSTATE

44000