The following table explains how session mode affects the timing of the ON COMMIT action.
| In this session mode … | The ON COMMIT action is applied at this time … |
|---|---|
| ANSI | when the application issues a COMMIT statement. |
| Teradata |
If you are using nested BT statements, then ON COMMIT is applied when the ET for the outermost BT is processed. |