Restrictions on Execution of Select Triggers

The following types of statements do not trigger any actions on select triggers:

• The triggering column or columns are not in the select list (for example, a column that appears in the WHERE clause of a SELECT statement does not execute a select trigger).
• The SELECT statement includes a remote table.
• The SELECT statement contains an aggregate function.
• The SELECT statement includes UNION or UNION ALL operations.
• The SELECT statement includes a DISTINCT or UNIQUE keyword.
• The UDR expression that contains the SELECT statement is not in the select list.
• The SELECT select statement appears within an INSERT INTO statement.
• The SELECT statement appears within a scroll cursor.
• The trigger is a cascading select trigger.

  A cascading select trigger is a trigger whose actions includes an SPL routine that itself has a triggering select statement. However, the actions of a cascading select trigger do not execute and the database server does not return an error.