I'm not sure of this, but I think the triggers fire sequentially by
definition and can't be in another thread. I know the first trigger runs
sequentially in the same thread with the program that does the insert
(or delete or update). I think this is required so you can rollback the
whole lot if you need to. When you have more than one trigger, all of
them would run in the same thread, I would think.
This might be a good question to put on the Midrange-L list. Birgitta
Hauser and others monitor that list who are quite knowledgeable about
the internal workings of the database engine.
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Yan.Zhang@xxxxxxxxxx
Sent: Wednesday, August 25, 2010 3:58 PM
To: Java Programming on and around the iSeries / AS400
Subject: SQL trigger question
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.
midrange.com
