what is a trigger and types of triggers

Answer Posted / satty

trigger is a set of actions that will be executed or implemented , when a defined event occur. triggering events are 1.insert, 2.update, 3.delete
triggers can be defined for a specific table and once defined then it is automatically active.
triggers are used to do a data validation and to maintain data integrity.
types of triggers:
before trigger and an after trigger.
triggers information can be stored in the sysibm.systriggers

Is This Answer Correct ?    7 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does db2 plan contain?

790


Define check constraint.

873


How do I copy a table in db2?

786


Give a brief description of db2 isolation levels?

818


What does a deadlock mean in DB2?

892


What is bind in db2?

816


What are the contents of a dclmgen?

874


What is the use of dclgen in db2?

828


How can the duplicate values be eliminated from db2 select?

898


What is reorg?

879


What is db2?

951


How to compare data between two tables in db2?

874


What is db2 bind process?

981


How do you stop a db2 database in linux?

788


How to execute stored procedures?

881