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 a cursor in programming?
How to retrieve rows from a db2 table in embedded sql?
What is the physical storage length of time data type?
What is the connection string to connect to the DB2 Database ?
What is database reorganization?
How do you select a row using indexes in db2?
How is deadlock resolved?
Is db2 a programming language?
What is dbrm? What it contains?
What is cobol db2?
Is db2 relational database?
Highlight all the advantages that are attached to a package.
How connect db2 database to datastage?
Give a brief description of db2 isolation levels?
Are views updateable?
