logo  
Google
 

DB2 SQL-Error: -160

SQLState: 42813

Short Description: THE WITH CHECK OPTION CANNOT BE USED FOR THE SPECIFIED VIEW

The WITH CHECK OPTION does not apply to a view definition under either of the following circumstances: v The view is read-only (for example, the view definition includes DISTINCT GROUP BY, or JOIN). v The view definition includes a subquery.System action: The statement cannot be executed. The specified view was not created. Programmer response: Refer to Chapter 5 of DB2 SQL Reference for rules regarding use of the WITH CHECK OPTION in view definitions.

 <-  BACK TO INDEX