We are running Informix 12.10.FC9W1 on Solaris. We have multiple insert triggers on a table. Is there a way to enforce that the triggers should get executed in a particular order?
I would consolidate them down to one trigger/trigger and stored procedure that does the steps you want in the correct order.
I think the original post is included. I'm posting from the website and it's kind of hazy as to what happens when you do that.