Re: SQL trigger question

[Alan Campin <alan0307d@xxxxxxxxx>]

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.