Reading about DB2 i discovered an interesting functionality, the INSTEAD OF triggers, which can be used to support insert, update and delete against complex views. I have not investigated their use yet, but they look a powerful mean. I’ll keep you posted on my experiments.
INSTEAD OF TRIGGER:
INSTEAD OF triggers describe how to perform insert, update, and delete operations against views that are too complex to support these operations natively. INSTEAD OF triggers allow applications to use a view as the sole interface for all SQL operations (insert, delete, update and select). Usually, INSTEAD OF triggers contain the inverse of the logic applied in a view body.