Results 1 to 3 of 3

Thread: insert trigger

  1. #1
    Join Date
    May 2004
    Location
    New York
    Posts
    248

    Unanswered: insert trigger

    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

  2. #2
    Join Date
    Nov 2004
    Posts
    143
    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

  3. #3
    Join Date
    May 2004
    Location
    New York
    Posts
    248
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •