Open topic with navigation
CREATE VIEW statement, for a view to be updatable, the
WHERE clause has the following characteristics:
LIMITkeyword is allowed.
INkeyword with either a list or a subquery to provide the IN list values is allowed.
WHEREclause criteria. In other words, you cannot update or delete a row that would not otherwise be selected from the view.
WHEREclause that contains an expression must have an expression that is one of the following:
/, Remainder (
||), Unary Minus Operator,
IS NOT NULL