Re: Trigger must know his status

["R. Bruce Hoffman, Jr." <rbruceh@xxxxxxxxxxxxx>]

If I understand your question correctly, you are asking if an IO operation
that would normally cause a trigger to fire, fails, can the trigger still
fire?

The short answer is no.

The long answer is that if you are doing a before trigger, and your
referential integrity constraints are not set to restrict, the trigger may
execute, but will be rolled back when the IO fails.

In other words, the journals may have the information, but the files won't.


===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"Those who would give up essential Liberty,
  to purchase a little temporary Safety,
  deserve neither Liberty nor Safety."

     - The Papers of Ben Franklin

-----Original Message-----
From: Simmerlein, Stefan <S.Simmerlein@guenther.de>
To: RPG400-L@midrange.com <RPG400-L@midrange.com>
Date: Wednesday, March 07, 2001 2:36 AM
Subject: Trigger must know his status


>Hi guys,
>
>a trigger program must do some actions before
>it ends.
>
>Example:
>
>SQL-Operation or WRITE/UPDATE Operation on a file
>--> TRIGGER
>
>If the SQL, the WRITE/UPDATE Oper. ends the trigger
>must do some operations
>
>
>Is this possible ?
>
>

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---