Can anyone show me a create view that allows the tables in the view to be updatable. Every view I create sets the syscat.views readonly column to Y. So I can use the update statement in my view. How do I Make that a N in the syscat.views table ????
Originally posted by sathyaram_s
If you are joining mutiple tables or using a function (like date(col2)) you cannot update it ...
Post a few of your views and someone may be able to help
I quote the manual here:
A column of a view is updatable if all of the following are true:
– the view is deletable
– the column resolves to a column of a base table (not using a dereference operation) and READ ONLY option is not specified
– all the corresponding columns of the operands of a UNION ALL have exactly matching data types (including length or precision and scale) and matching default values if the fullselect of the view includes a UNION ALL
A view is updatable if ANY column of the view is updatable."