Re: Triggers?

If you do: create trigger xxxxx insert on tab1 after (update somedb@remoteserver:sometable set x=somevalue, update tab1 set col1 = "blah blah" ) it works, probably cause of 2 phase commit needed. This is a TODO for Informix: Get rid of this stupid error described below !!! Panayiotis Xeros wrote: > > The following trigger definition in Informix 7.2x On-Line Server, > produces a runtime error: > > create trigger xxxxx > insert on tab1 > after (update tab1 set col1 = "blah blah" )> > I read in Error Messages manual that you can't have SQL statement that > acts on the triggering table. > It also doesn't work if you replace the SQL with EXECUTE PROCEDURE . > Can > anybody tell me if there is a way to override this situation. (drop > dead is not an answer) > > Thanks, > reply to pxeros@teemail.gr