Can I use multiple BEGIN ATOMIC/END statements in a single trigger? e.g.
BEGIN ATOMIC
statement1;
END
BEGIN ATOMIC
statement2;
END

The reason I am asking is I have two different actions that need to take place from the trigger and I want them to be independent of each other e.g. if first one fails then the second one should execute. And if yes, then does the Syntax look ok?
Any help on this would be greatly appreciated.

Thank you.

The way I read the SQL syntax diagrams, No.

Andy

Is there any way to do what I am trying to accomplish? I have one INSERT statement in the trigger that writes to a table. I need to modify the trigger to add another insert statement that would write to a different table. I want those two actions independent of each other i.e. even if the first one fails the second one should still execute.

Thanks.

Is there any way to do what I am trying to accomplish? I have one INSERT statement in the trigger that writes to a table. I need to modify the trigger to add another insert statement that would write to a different table. I want those two actions independent of each other i.e. even if the first one fails the second one should still execute.

Thanks.

Starting with v9, you can call a stored procedure from a trigger.