Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Can i use more than one trigger for one event and table?
0 views
Skip to first unread message
Michael Justin
Jul 24, 2000, 3:00:00 AM7/24/00
to
Hello,
i have been working with InterBase, and there it was possible to define more
than one trigger for each event. Even the execution order was under control.
Is the same possible for DB2 (i know it is not possible for DB2/400)?
Greetings,
Michael Justin
Blair Kenneth Adamache
Jul 24, 2000, 3:00:00 AM7/24/00
to
Yes this is possible.
Serge Rielau
Jul 24, 2000, 3:00:00 AM7/24/00
to
Yes, you can have multiple triggers on a given table. The execution
order is by creation time (older triggers go first).
order is by creation time (older triggers go first).
Cheers
Serge
Kent Milligan
Jul 25, 2000, 3:00:00 AM7/25/00
to
Michael BTW both of these Triggers restrictions are being worked on right now,
so that these issues don't exist in the future on the AS/400.
so that these issues don't exist in the future on the AS/400.
--
Kent Milligan, DB2 & BI team
PartnerWorld for Developers, AS/400
km...@us.removethis.ibm.com GO HAWKEYES!!
(opinions stated are not necessarily those of my employer)
0 new messages