# Triggers and procedures on ADABAS

**URL:** <https://techcommunity.softwareag.com/t/triggers-and-procedures-on-adabas/175683>\
**Category:** Forum\
**Tags:** Adabas-Natural, Adabas, Adabas-on-Mainframes, Adabas-Utilities-on-Mainframes\
**Created:** [April 12, 2014, 2:43pm UTC](https://techcommunity.softwareag.com/t/triggers-and-procedures-on-adabas/175683 "2014-04-12T14:43:11Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![blessing](https://avatars.discourse-cdn.com/v4/letter/b/90db22/32.png) [@blessing](https://techcommunity.softwareag.com/u/blessing)\
**Post date:** [April 12, 2014, 2:43pm UTC](https://techcommunity.softwareag.com/t/triggers-and-procedures-on-adabas/175683/1 "2014-04-12T14:43:11Z")

</div>

I have not used triggers before but I want to trap certain data manipulations in a certain file and I wonder if triggers can be used to create a before image file especially when a delete is done by the DBA or programmer?  
In our AOS the Trigger option is disabled, how can I enable this option in AOS?  
I would appreciate any help on the matter.

---

<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 13, 2014, 9:18am UTC](https://techcommunity.softwareag.com/t/triggers-and-procedures-on-adabas/175683/2 "2014-04-13T09:18:16Z")

</div>

Adabas Stored Procedures & Triggers (aka SPT) are an add-oin product to Adabas, sou you would first have to check if your site got a license for it and the product is installed.

Secondly, from the documentation

> [@](#):
>
> Trigger Maintenance is not fully operational until the required file-field tables and trigger definitions are added.

In case you do not have SPT licensed your requirement can probably be satisfied by extracting the information from the PLOGs.

---

<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:** [April 14, 2014, 6:45pm UTC](https://techcommunity.softwareag.com/t/triggers-and-procedures-on-adabas/175683/3 "2014-04-14T18:45:41Z")

</div>

Hi,

Adabas Triggers & Procedures require an Adabas Online Services license (in terms of a contract)

Regards,  
Wolfgang

---

<div class="post-metadata">

**Author:** ![blessing](https://avatars.discourse-cdn.com/v4/letter/b/90db22/32.png) [@blessing](https://techcommunity.softwareag.com/u/blessing)\
**Post date:** [April 14, 2014, 7:05pm UTC](https://techcommunity.softwareag.com/t/triggers-and-procedures-on-adabas/175683/4 "2014-04-14T19:05:25Z")

</div>

Thank you for the response I will look into the company’s contract in this regard and take it from there.

---

<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:30pm UTC](https://techcommunity.softwareag.com/t/triggers-and-procedures-on-adabas/175683/5 "2021-04-02T15:30:50Z")

</div>


