INSTEAD OF triggers on views

A view is a synthetic table that you create with the CREATE VIEW statement and define with a SELECT statement. Each view consists of the set of rows and columns that the SELECT statement in the view definition returns each time you refer to the view in a query. To insert, update, or delete rows in the base tables of a view, you can define an INSTEAD OF trigger.

Unlike a trigger on a table, the INSTEAD OF trigger on a view causes HCL OneDB™ to ignore the triggering event, and instead perform only the triggered action.

For information on the CREATE VIEW statement and the INSTEAD OF trigger syntax and rules, including an example of an INSTEAD OF trigger that will insert rows on a view, see the HCL OneDB Guide to SQL: Syntax.