If I want to get separate threads going -- all these threads run parallel.
How do I do it?
YanZ
From:
"Clapham, Paul" <pclapham@xxxxxxxxxxxxx>
To:
"Java Programming on and around the IBM i" <java400-l@xxxxxxxxxxxx>
Date:
08/25/2010 05:16 PM
Subject:
RE: SQL trigger question
Sent by:
java400-l-bounces@xxxxxxxxxxxx
That seems perfectly normal to me. In fact I would be surprised if the
database software started separate threads for each of the triggers.
That would be just asking for trouble.
PC2
-----Original Message-----
From: java400-l-bounces@xxxxxxxxxxxx
[mailto:java400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Yan.Zhang@xxxxxxxxxx
Sent: August 25, 2010 13:58
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
