Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2012
    Posts
    3

    Unanswered: Insert trigger that will not prevent insert in event of failure

    I am trying to find a way to create an insert for each row trigger that will never prevent the insert from committing regardless of it's contents.

    I need to ensure that the inserts always happen, i just need to do some other work if possible in the trigger.

    Thanks in advance.

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    did you try using a stored procedure invoked by the trigger?

    in the stored procedure, you can handle the behaviour at error catch

    E.

  3. #3
    Join Date
    Feb 2012
    Posts
    3
    Hmm, looks like the forum ate my post with links. Basically I found within IBM's documentation that ON-EXCEPTION doesn't do anything if used within a user created procedure that is called from a trigger.

Posting Permissions

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