IBM® Informix® 12.10

Views

Select triggers execute a triggered action for views whose base tables contain a reference to a triggering column. You cannot, however, define a Select trigger on a view.

Suppose you create the following view:
CREATE VIEW view_tab AS
   SELECT * FROM tab_a;
The following statements execute a triggered action on the hits_trig trigger for each instance of a row that the view returns:
SELECT * FROM view_tab;

SELECT col_a FROM tab_a;
Parent topic: SELECT statements that execute triggered actions

Examples exchange | Troubleshooting

To find the PDF, see Publications for the IBM Informix 12.10 family of products.
For the release notes, documentation notes, and/or machine notes, see the Release Notes page.