# SHARED HOLD and timeout ?

**URL:** <https://techcommunity.softwareag.com/t/shared-hold-and-timeout/170648>\
**Category:** Forum\
**Tags:** Adabas-Natural, Natural, Natural-on-Mainframes\
**Created:** [April 10, 2013, 12:04pm UTC](https://techcommunity.softwareag.com/t/shared-hold-and-timeout/170648 "2013-04-10T12:04:04Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ronald\_Wijchers](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@Ronald\_Wijchers](https://techcommunity.softwareag.com/u/Ronald_Wijchers)\
**Post date:** [April 10, 2013, 12:04pm UTC](https://techcommunity.softwareag.com/t/shared-hold-and-timeout/170648/1 "2013-04-10T12:04:04Z")

</div>

I am wondering if somebody from SAG can chime in and answer this for me :

what would happen if I do a READ/FIND with shared hold mode S without actually being in a transaction ? Natural does allow it (already tried), but when is the record released again for others to update ? Since I am not in a transaction, no ET or BT is issued so that cannot be the ‘trigger’ to release it.

Ronald

---

<div class="post-metadata">

**Author:** ![Neuler\_Coelho](https://avatars.discourse-cdn.com/v4/letter/n/f475e1/32.png) [@Neuler\_Coelho](https://techcommunity.softwareag.com/u/Neuler_Coelho)\
**Post date:** [April 25, 2013, 2:22am UTC](https://techcommunity.softwareag.com/t/shared-hold-and-timeout/170648/2 "2013-04-25T02:22:25Z")

</div>

If have one instruction of READ/FIND without a instruction of update data no have a start of control transaction. But, if has a instruction of update, the Natural’s Nucleo make a implicit control transaction.

Is it your question?

---

<div class="post-metadata">

**Author:** ![Douglas\_Kelly](https://sea1.discourse-cdn.com/techcommunity/user_avatar/techcommunity.softwareag.com/douglas_kelly/32/102_2.png) [@Douglas\_Kelly](https://techcommunity.softwareag.com/u/Douglas_Kelly)\
**Post date:** [April 25, 2013, 3:07am UTC](https://techcommunity.softwareag.com/t/shared-hold-and-timeout/170648/3 "2013-04-25T03:07:14Z")

</div>

if you use SHARED HOLD, you are implicitly in a transaction that needs to be terminated by an END TRANSACTION or BACKOUT TRANSACTION.

See the documentation, e.g. [http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat823mf/sm/find.htm](http://techcommunity.softwareag.com/ecosystem/documentation/natural/nat823mf/sm/find.htm)  
MODE = S Until the logical transaction is terminated. Releases the record from shared hold when a logical transaction is terminated with an END TRANSACTION or BACKOUT TRANSACTION statement.  
MODE=Q and MODE=S ensure that the record being read cannot be updated concurrently by other users until it has been released from hold again.

---

<div class="post-metadata">

**Author:** ![Ronald\_Wijchers](https://avatars.discourse-cdn.com/v4/letter/r/e5b9ba/32.png) [@Ronald\_Wijchers](https://techcommunity.softwareag.com/u/Ronald_Wijchers)\
**Post date:** [April 30, 2013, 8:11am UTC](https://techcommunity.softwareag.com/t/shared-hold-and-timeout/170648/4 "2013-04-30T08:11:27Z")

</div>

ok, so using shared hold with mode S but without actually being in a logical transaction would automatically put the records I want to put in shared hold into the other ‘official’ hold ? I guess that makes some sense somewhere.

I know it’s a far fetched example, but I just happened to notice that Natural allowes this situation so I wondered what would happen.

thanks,  
Ronald

---

<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:28pm UTC](https://techcommunity.softwareag.com/t/shared-hold-and-timeout/170648/5 "2021-04-02T15:28:36Z")

</div>


