"Read-only" views, non-updateable columns
If the object you are editing is a view, it is possible that one or more columns within the view are marked as non-updateable in the Db2® catalog. In Db2® parlance, such a view is referred to as a read-only view.
If you attempt to edit a read-only view that contains only non-updateable columns, FM/Db2 displays a Browse session (instead of an Edit session) and issues an advisory message at the start of the session. Otherwise (that is, if the read-only view contains at least one updateable column), FM/Db2 displays a File Manager/Db2 editor session showing the non-updateable columns as protected and issues an advisory message as the start of the FM/Db2 editor session. If you edit a view containing one or more non-updateable columns, not all edit operations are possible.
If you edit a table that contains one or more columns, excluding ROWID columns, that are marked as non-updateable in the Db2® catalog (such as a Db2® catalog table), FM/Db2 displays a File Manager/Db2 editor session showing the non-updateable columns as protected and issues an advisory message at the start of the FM/Db2 editor session. If you edit a table containing one or more non-updateable columns, excluding ROWID columns, not all edit operations are possible.
Related tasks