× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



There is a "FOR EACH STATEMENT" or "FOR EACH ROW" option in the create
trigger. The first is the default. I think it will cause the triggers to
fire once if there are several rows inserted in the same statement.


Alan Campin wrote:
Any commit control in the mix.

The triggers will fire sequentially I think based on the order the triggers
where added to the table.

On Wed, Aug 25, 2010 at 2:58 PM, <Yan.Zhang@xxxxxxxxxx> wrote:

I have 3 "after update" triggers on Table0: T1, T2, and T3. All these 3
triggers are built on Table0.
T1 inserts some records into Table1;
T2 inserts some records into Table2;
T3 inserts some records into Table3.

So, after Table0 is updated, I think T1,T2.and T3 would be launched at the
same time.
But why in my experiments it shows the "insert into...." for 3 tables are
executed sequentially? i.e. A bunch of records are inserted into Table1,
then a bunch of records are inserted into Table2, then a bunch of
records are inserted into Table3.


thanks,
YanZ
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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

This mailing list archive is Copyright 1997-2024 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].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.