thank you very much, I understand the general meaning of how it works
and learned somthing new today.

I can however see some problems if triggers are used to general validation

1. Trigges can be turned off and nobody will notice unless you have a
mecanism that monitors the active triggers.

2. One table may have up to 200 triggers, how can one ensure that
the validation trigger is called first?

3. Does the method stop other triggers for being executed?

On Mon, Oct 5, 2015 at 5:43 PM, Buck Calabro <kc2hiz@xxxxxxxxx> wrote:

On 10/5/2015 10:50 AM, Henrik Rützou wrote:

do you have an example

Found an old SQL trigger example here:

'We may be interested in firing an error from an SQL trigger to avoid
the completion of an INSERT, UPDATE, or DELETE operation, to reinforce a
business rule.'


This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
To post a message email: WEB400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/web400
or email: WEB400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/web400.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2020 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].