Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why do we use cursor?
How can you classify the locks in db2?
On which levels locks can be applied?
define clustering index.
What is check constraint in db2?
List down the types of triggers in the db2 database?
What is meant by dclgen?
How do I delete a table in database?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
What is role in db2?
What os does db2 run on?
What is nvl in db2?
What is consistency token in db2?
What is bufferpool in db2?
What is difference between isnull and coalesce?
