Effects On Trigger When New File Field Is Added

Effects On Trigger When New File Field Is Added

This article will explain the effect of triggers when a new file field is added to the file having a trigger attached to it.

File1

A          R RTGPF1             
A            TOTAL          9P 0
A            REMARKS       50A 

File1 has a trigger attached to it.

When a new file field is added to the File1

A            STUDENT       10A

Then, Effects on the trigger will be:

Case: 1

• The trigger is activated when there is any manipulation on any of the column
• The trigger is activated when there is any manipulation on any specific column

No need to re-create the trigger.

Case: 2

If an SQL statement is used inside the trigger then it will not fetch the latest added field.

The trigger needs to be re-created.

Case: 3

If the transition table Old Table and New Table is used inside the trigger then it will not fetch the latest added field.

The trigger needs to be re-created.

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)
• Trigger Limitations and Program Attributes
• SYSTRIGGERS Catalog Table for SQL Trigger
• SYSTRIGDEP Catalog Table for SQL Trigger
• SYSTRIGUPD Catalog Table for SQL Trigger
• SYSTRIGCOL Catalog Table for SQL Trigger