Re: Elevator speech on DB2 development and web enablement?

Buck

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:

Buck

do you have an example

Found an old SQL trigger example here:

http://www.redbooks.ibm.com/redbooks/SG246503/wwhelp/wwhimpl/js/html/wwhelp.htm
'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.'

--
--buck

--
This is the Web Enabling the IBM i (AS/400 and iSeries) (WEB400) mailing
list
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.