6. QUEL and EQUEL Statements : Define View Statement—Define Virtual Tables : Considerations
 
Share this page                  
Considerations
In general, no updates are supported on views derived from more than one base table.
You cannot update columns that are in the where clause of the view definition.
You can only update simple columns from the target_list of a view definition; you cannot update columns that are not simple columns (such as aggregates, derived columns, or constants).
You cannot update a row with a value that causes the row to be dropped from the view.
You can only define views based on tables for which you have retrieve permission.
When you destroy a table that is referenced by a view, the DBMS Server automatically destroys the view.