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
How to check last update on table in db2?
What is consistency token in db2?
How connect db2 database to datastage?
What does db2 stand for?
Explain in brief how does db2 determine what lock-size to use?
How to test SQL -911 error while developing COB-DB2 program
What is db2 command?
How do I import data from excel to db2?
What is dbrm? What it contains?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
Highlight all the advantages that are attached to a package.
What is the use of dclgen in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
How do I connect my db2 database to ibm?
Is db2 a mainframe?
