Re: Is there a way to add a Where clause to an SQL After Insert Trigger?

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

Hi Jeff,

You cannot specify criteria for an insert trigger.
The logic would have to be placed within the trigger program itself.

Hope this helps.

Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Work: (416) 675-9200 ext. 89224
Cell: (416) 317-3144




On 30 April 2015 at 15:30, Jeff Young <jyoung0950@xxxxxxxxx> wrote:

> V6R1.
>
> Using examples provided earlier this month by Chuck, I have successfully
> created After Insert and After Update SQL triggers.
> I would like to be able to have a filter on the After Insert trigger so
> that only records meeting my selection criteria will be processed.
> Is this possible?
> I have not been able to find anything in the SQL Reference Manual regarding
> this.
>
>
> TIA,
>
> Jeff Young
> Sr. Programmer Analyst