# End Transaction and Backout Transaction

**URL:** <https://techcommunity.softwareag.com/t/end-transaction-and-backout-transaction/185399>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Mainframes\
**Created:** [November 30, 2015, 9:26am UTC](https://techcommunity.softwareag.com/t/end-transaction-and-backout-transaction/185399 "2015-11-30T09:26:32Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Vasanth\_Murali](https://avatars.discourse-cdn.com/v4/letter/v/ce73a5/32.png) [@Vasanth\_Murali](https://techcommunity.softwareag.com/u/Vasanth_Murali)\
**Post date:** [November 30, 2015, 9:26am UTC](https://techcommunity.softwareag.com/t/end-transaction-and-backout-transaction/185399/1 "2015-11-30T09:26:32Z")

</div>

Guys,

My understanding is that if I use an End transaction all the updates or stores will be completed and we won’t be able to revert back.

But I used a Backout transaction in the immediate next line of End transaction. The database didn’t get updated.

Will backout transaction work even after End transaction

---

<div class="post-metadata">

**Author:** ![Giles](https://avatars.discourse-cdn.com/v4/letter/g/c68b51/32.png) [@Giles](https://techcommunity.softwareag.com/u/Giles)\
**Post date:** [November 30, 2015, 11:50am UTC](https://techcommunity.softwareag.com/t/end-transaction-and-backout-transaction/185399/2 "2015-11-30T11:50:35Z")

</div>

this sounds like a garbled interview question.

---

<div class="post-metadata">

**Author:** ![Ralph\_Zbrog](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/ralph_zbrog/32/78_2.png) [@Ralph\_Zbrog](https://techcommunity.softwareag.com/u/Ralph_Zbrog)\
**Post date:** [November 30, 2015, 5:15pm UTC](https://techcommunity.softwareag.com/t/end-transaction-and-backout-transaction/185399/3 "2015-11-30T17:15:19Z")

</div>

Once changes have been committed with an ET they cannot be reversed with a BT. A BT backs out changes up to the prior ET.

---

<div class="post-metadata">

**Author:** ![Brian\_Johnson1](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/brian_johnson1/32/163_2.png) [@Brian\_Johnson1](https://techcommunity.softwareag.com/u/Brian_Johnson1)\
**Post date:** [November 30, 2015, 5:34pm UTC](https://techcommunity.softwareag.com/t/end-transaction-and-backout-transaction/185399/4 "2015-11-30T17:34:36Z")

</div>

Yeah - the nature of this question makes me suspect an unclear understanding of the concept. No database would ever allow you to commit (ET) a transaction that you did a rollback (BT) to already. After a rollback (BT) you can re-execute the transactions again and then commit (ET) those.

Or the reverse, if you performed transactions and then did a commit (ET), you cannot then rollback (BT) to undo them. You would have to apply the transactions in reverse and then commit (ET) that to have the effect of a rollback (BT) after commit (ET).

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [November 30, 2015, 7:59pm UTC](https://techcommunity.softwareag.com/t/end-transaction-and-backout-transaction/185399/5 "2015-11-30T19:59:21Z")

</div>

> [@Vasanth Murali](#):
>
> But I used a Backout transaction in the immediate next line of End transaction. The database didn’t get updated.

Then you didn’t update as you think you did in the first place, there’s absolutely no way this can happen.

---

<div class="post-metadata">

**Author:** ![Vasanth\_Murali](https://avatars.discourse-cdn.com/v4/letter/v/ce73a5/32.png) [@Vasanth\_Murali](https://techcommunity.softwareag.com/u/Vasanth_Murali)\
**Post date:** [December 1, 2015, 6:02am UTC](https://techcommunity.softwareag.com/t/end-transaction-and-backout-transaction/185399/6 "2015-12-01T06:02:39Z")

</div>

Yeah guys,

I was wrong. Today I checked the code and the updates really happened.

Sorry guys ☹

Vasanth

---

<div class="post-metadata">

**Author:** ![system](https://global.discourse-cdn.com/techcommunity/original/3X/c/d/cd19967bb605d28a72d77eb83a1cae22f3df2eb8.svg) [@system](https://techcommunity.softwareag.com/u/system)\
**Post date:** [April 2, 2021, 3:34pm UTC](https://techcommunity.softwareag.com/t/end-transaction-and-backout-transaction/185399/7 "2021-04-02T15:34:47Z")

</div>