Effects On Trigger When New File Field Is Added

Effects On Trigger When New File Field Is Added
Effects On Trigger When New File Field Is Added, sql trigger, db2 triggers, ibmi, as400
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

Post a Comment

© AS400 and SQL Tricks. All rights reserved. Developed by Jago Desain