INSTEAD OF Triggers on Views (IDS)

A view is a virtual 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. Since a view is a virtual table, to insert, update, or delete rows in a view, you must use the INSTEAD OF trigger.

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 IBM Informix: Guide to SQL Syntax.