var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
did you try using a stored procedure invoked by the trigger?
in the stored procedure, you can handle the behaviour at error catch
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.