Trigger if updating then
Boolean UPDATE() returns TRUE regardless of whether an INSERT or UPDATE attempt is successful.
Our technologist looks at trigger maintenance and implementation challenges.That syntax allows for the specification of the events that can be handled by the trigger.Usage of the SQL multiple event trigger support requires that DB2 PTF Group SF99701 level 23 be applied on your system (see SF99701 Level 22 enhancements).With the new support, it is now possible to have only one source SQL trigger that needs to be updated to accommodate future changes to your database and business requirements.The support introduces trigger predicates and new keywords that can be used to control the logic flow in the trigger based on the event that caused the trigger to be invoked.
Search for trigger if updating then:
However, in some cases, we have to use triggers and it is important to develop them correctly.