1. While DB procedures are called explicitly from the programming language of an application, triggers are specialized procedures that run implicitly on a base table or a view table built on this base table after executing a DML statement.
2. The conditions under which a trigger is to be executed can be restricted further.
3. The trigger is executed for each row to which the SQL statement refers. The trigger code can access both the old values of the row (values before update or deletion) and the new values (values after update or insertion).
4. A trigger can call other triggers implicitly and DB procedures explicitly.
5. Triggers can be used to check complicated integrity rules, to initiate derived database modifications for this or other rows or to implement complicated rules for access protection.
6. For the programming of triggers, refer to the manuals of the corresponding ADABAS components.