In this post, you’ll learn about the error message -160 the with check option cannot be used for the specified view in the IBM DB2 database , the reason why it occurs along with the solution to fix it
IBM DB2 Error Message
-160 the with check option cannot be used for the specified view
Reason for the Error
The WITH CHECK OPTION does not apply to a view definition under either of the following circumstances:� *�� The view is defined as ‘read-only’ (for example, the view is defined���� on more than one base table or other view).� *�� The SELECT statement of the view contains a subselect, a GROUP BY or���� HAVING clause, or the DISTINCT keyword.
Solution
Correct the syntax of the WITH CHECK OPTION keyword in the CREATE VIEW statement.
