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
What is the maximum size of varchar data type in db2?
What is cobol db2?
Is ibm db2 open source?
Highlight all the advantages that are attached to a package.
How to find the number of rows in db2 tables?
What is dbrm? What it contains? When it will be created?
Define declaration generator (dclgen).
What is runstats utility in db2?
How to check table size in db2 sap?
Define sqlca.
what is a corelated subquerry?
Explain various types of locks in db2?
How connect db2 database to datastage?
How many databases can be created inside an instance in db2 ?
How do I connect my db2 database to ibm?