On Wed, 2004-05-05 at 05:30, Rod Taylor wrote:
> Yup.. And some of us intend on wrapping every single statement in a
> subtransaction so we can rollback on an error without aborting the main
> transaction.
>
That is exactly what is needed to achieve full Oracle & DB2
compatibility.
I suggest that this should be a session settable parameter, to allow
session transaction semantics to mimic particular DBMS.
I want the behaviour but not the effort...
Best Regards, Simon Riggs