Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Location
    Australia
    Posts
    46

    Question Unanswered: Disbale Trigger?

    Hi All,

    Could anyone help me on how to disable a trigger on a Informix Dynamic Server Database. I am writing a Visual Basic Application however I need the Application to disable an Insert and Update trigger when it writes to this table. In MS SQL 7, I can disable a trigger using "ALTER TABLE", is there anything in Informix that can do the same thing or would I need to drop it and recreate it each time??

    Thanks
    Anthony

  2. #2
    Join Date
    Aug 2002
    Location
    Bonn/Germany
    Posts
    152
    Reading the manual (SQL Syntax Guide) might sometimes
    help.....

    set triggers for <tablename> disabled

    OR

    set triggers <triggername> disabled

    Best regards

    Eric
    --
    IT-Consulting Herber
    WWW: http://www.herber-consulting.de
    Email: eric@herber-consulting.de

    ***********************************************
    Download the IFMX Database-Monitor for free at:
    http://www.herber-consulting.de/BusyBee
    ***********************************************

Posting Permissions

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