withnams
New User
Joined: 06 Jul 2005 Posts: 26 Location: Chennai
|
|
|
|
Yes we can update a view provided the rows of view are same as rows of table.
When you create a view, you can define it as either a read-only view or as an
updatable view. The SELECT statement of a view determines whether the view is
read-only or updatable. Generally, if the rows of a view can be mapped to rows of the
base table, then the view is updatable.
The rules for creating updatable views are complex and depend on the definition of the
query. For example, views that use VALUES, DISTINCT, or JOIN features are not
updatable. You can easily determine whether a view is updatable by looking at the
READONLY column of SYSCAT.VIEWS: Y means it is ready-only and N means it is
not. |
|