Guys, I need to create two insert triggers on the same table, I know Informix does not allow it. Is there a way around?

both triggers need to execute two different stored procedures

Thanks in advance

hi,

Why can't you execute both procedures (one after the other) as part of trigger action?

CREATE TRIGGER <name>
INSERT|DELETE|UPDATE OF <column-name>, <column-name> {choose one}
ON <table>
[REFERENCING NEW AS <name>] {optionally choose this clause for INSERT or UPDATE triggers}
[REFERENCING OLD AS <name>] {optionally choose this clause for DELETE or UPDATE triggers}
{specify at least one trigger action: BEFORE, FOR EACH ROW, AFTER}
BEFORE [WHEN(<sqlcondition>)] (<actionstatement>)
FOR EACH ROW [WHEN(<sqlcondition>)] (<actionstatement>)
AFTER [WHEN(<sqlcondition>)] (<actionstatement>)
;

regards,

Nitin

thanks, I thought about executing both but syntax did not work(have not done this in a while)) out of practice) got it to run

Thanks