In this post, you’ll learn about the error message -161 the insert or update is not allowed because a resulting row does not satisfy the view definition in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-161 the insert or update is not allowed because a resulting row does not satisfy the view definition
Reason for the Error
The WITH CHECK OPTION applies to the view that is the object of the INSERT or UPDATE statement.� Consequently, all attempts to insert or update rows in that view are checked to ensure that the results will conform to the view definition.
Examine the view definition to determine why the requested INSERT or UPDATE was rejected.� Note that this may be a data-dependent cond