|Trigger Limitations and Program Attributes|
This article has some basic information related to triggers and trigger programs.
Trigger Program Attributes
- The trigger is a CLE program
- The activation group for the trigger program is *CALLER
- Special registered values are saved before the trigger gets activated and it gets restored once returned from the trigger
- The default storage model is STGMDL(SNGLVL)
- The maximum number of triggers per table is 300
- Maximum runtime depth of cascading trigger is 200 or maximum storage of job session, whichever come first
DB2ROW vs DB2SQL
The trigger gets activated (after or before) at each row.
A single statement can manipulate (add/delete/insert) multiple rows at once and the trigger will get executed for each manipulated.
The trigger gets activated only after the complete statement is executed.
A single statement can manipulate (add/delete/insert) multiple rows at once but the trigger will get executed only completion of all the rows manipulation.
Read also :
- SQL Triggers concept in IBM i DB2
- Syntax for Create Trigger in IBM i AS400
- Simple SQL Trigger Example
- Conditional SQL Trigger Example
- OF Clause in SQL Trigger
- Multiple Event Execution Through SQL Trigger
- Change Row Before Inserting In Table (Before SQL Trigger)
- Stored Procedure calling in SQL Trigger
- Transition Tables in SQL Triggers
- Error Handling in SQL Trigger Using Signalling
- Self Referencing SQL trigger
- INSTEAD OF SQL Trigger (Adding / Deleting / Inserting record in the table through SQL View)
- Effects On Trigger When New File Field Is Added
- SYSTRIGGERS Catalog Table for SQL Trigger
- SYSTRIGDEP Catalog Table for SQL Trigger
- SYSTRIGUPD Catalog Table for SQL Trigger
- SYSTRIGCOL Catalog Table for SQL Trigger