# Insert/Update and Delete in Adabas Files

**URL:** <https://techcommunity.softwareag.com/t/insert-update-and-delete-in-adabas-files/190307>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Basics-on-Mainframes\
**Created:** [August 23, 2016, 8:17am UTC](https://techcommunity.softwareag.com/t/insert-update-and-delete-in-adabas-files/190307 "2016-08-23T08:17:58Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![subba](https://avatars.discourse-cdn.com/v4/letter/s/eb8c5e/32.png) [@subba](https://techcommunity.softwareag.com/u/subba)\
**Post date:** [August 23, 2016, 8:17am UTC](https://techcommunity.softwareag.com/t/insert-update-and-delete-in-adabas-files/190307/1 "2016-08-23T08:17:58Z")

</div>

Hi All,

Here are my questions please show me a way to achieve the same.

1. Can we detect changes (inserts and updates) of records in ADABAS tables? If yes, what are the possible options to detect the same.

2. If we can detect changes to the records, can we:-  
1. detect which records got changed (updated and inserted)  
2. detect what changed in the records (what field got updated)

3. When in the transaction cycle does this change-detect mechanism work.

Thanks

---

<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:** [August 23, 2016, 2:26pm UTC](https://techcommunity.softwareag.com/t/insert-update-and-delete-in-adabas-files/190307/2 "2016-08-23T14:26:10Z")

</div>

What are you trying to achieve ?

Do you require “real time” tracking ?

If not then check the protection log (PLOG) which tracks the modifications (mainly for recovery purposes).

---

<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:** [August 23, 2016, 5:06pm UTC](https://techcommunity.softwareag.com/t/insert-update-and-delete-in-adabas-files/190307/3 "2016-08-23T17:06:40Z")

</div>

Search these forums for “change data capture” or search the Internet for third-party CDC products for Adabas (I know of two).

---

<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:** [August 30, 2016, 9:31am UTC](https://techcommunity.softwareag.com/t/insert-update-and-delete-in-adabas-files/190307/4 "2016-08-30T09:31:24Z")

</div>

Adabas Triggers (SPATS) might help.

---

<div class="post-metadata">

**Author:** ![Ch\_Mark](https://avatars.discourse-cdn.com/v4/letter/c/58956e/32.png) [@Ch\_Mark](https://techcommunity.softwareag.com/u/Ch_Mark)\
**Post date:** [October 5, 2016, 6:49am UTC](https://techcommunity.softwareag.com/t/insert-update-and-delete-in-adabas-files/190307/5 "2016-10-05T06:49:36Z")

</div>

I think you can’t check it.

---

<div class="post-metadata">

**Author:** ![anon72918622](https://avatars.discourse-cdn.com/v4/letter/a/ecae2f/32.png) [@anon72918622](https://techcommunity.softwareag.com/u/anon72918622)\
**Post date:** [October 6, 2016, 9:41am UTC](https://techcommunity.softwareag.com/t/insert-update-and-delete-in-adabas-files/190307/6 "2016-10-06T09:41:14Z")

</div>

Try System Fields for inserts and updates.

---

<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:36pm UTC](https://techcommunity.softwareag.com/t/insert-update-and-delete-in-adabas-files/190307/7 "2021-04-02T15:36:47Z")

</div>