Trigger Limitations and Program Attributes

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)

Trigger Limitations

• 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

DB2ROW

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.

DB2SQL

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.

Related Post

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