trigger question

I want to define a insert type trigger on a table. when the insert sql succeed on the base table, I want the trigger body will be executed,I don't care for whether the trigger body will be committed or rollbacked; When the insert SQL failed on the base table,the trigger willn't be executed. How to implement it in IDS? thanks for your time.

INSERT triggers will fire before, after, or for each row of the insert. You have to control, using transaction commit or rollback whether the triggered action is committed or rolled back as it is part of the transaction that controls the insert itself. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, May 9, 2011 at 11:24 PM, CHUAN LU <luchuan114@sina.com> wrote: > I want to define a insert type trigger on a table. > when the insert sql succeed on the base table, I want the trigger body will > be > executed,I don't care for whether the trigger body will be committed or > rollbacked; > When the insert SQL failed on the base table,the trigger willn't be > executed. > How to implement it in IDS? thanks for your time. > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --20cf307f3bfc9b696804a2e947fe