Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    38

    Unanswered: Disabling specific triggers

    How can I disable a specific trigger (there may be more than one triggers on a table) of a specific table?

    I found "SET TRIGGERS" statement with "DISABLE" or "ENABLE" from IBM documentation but it does say anything about where to use table name and trigger name (if that is the way to go).

    Can someone please help me finding the correct syntax for this? Thanks a lot, in advance. Best regards.

  2. #2
    Join Date
    Aug 2003
    Location
    Argentina
    Posts
    780
    Hi,
    Please test with set triggers "triggername" disabled.

    Gustavo.

Posting Permissions

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