If a database view contains only one single table, data can be inserted in this table with the view (seemaintenance status). You have the following options for the contents of the table fields not contained in the view:
You should therefore only insert data in the table with a database view ifinitial values are defined for all the table fields not contained in the view.
Changing data records that already exist with a database view is not critical if the database view contains all the key fields of the table.
When you insert data records withmaintenance views or projection views, all the table fields not contained in the view are assigned the default value of the field. This does not depend on whether the field is defined in the database as NOT NULL. This avoids NULL values in these fields.