Re: Trigger programme without a trigger.

We use triggers to have uniform logging of database changes. Does that
count as 'correct use' in your book?


Peter Colpaert
Software Engineer, Consumer Luminaires

Industrieterrein Satenrozen 11, 2550 Kontich, Belgium
Tel. +32/ 3 450 74 09, Fax +32/ 3 450 74 33, Internal 1317
peter.colpaert@xxxxxxxxxxx, www.philips.com



The information contained in this message is confidential and may be
legally privileged. The message is intended solely for the addressee(s).
If you are not the intended recipient, you are hereby notified that any
use, dissemination, or reproduction is strictly prohibited and may be
unlawful. If you are not the intended recipient, please contact the sender
by return e-mail and destroy all copies of the original message.






Simon Coulter <shc@xxxxxxxxxxxxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
11/06/2008 09:56
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
Re: Trigger programme without a trigger.




That would be an incorrect use of a trigger program. Triggers are to
extend referential integrity--using them for anything else is a
flawed design. I know many of the IBM examples show triggers being
used to e-mail, fax, and a bunch of other stuff that has no business
being performed by a trigger but just 'cause it's from IBM don't make
it right.

Even in the rare case of no access to the source code so using a
trigger "solves the problem" it is still bad design. There are
alternatives that should be used instead.

Regards,
Simon Coulter.