Answer Posted / anitha
A trigger is a set of actions that are run automatically when a specified change operation is performed on a specified table. The change operation can be an SQL INSERT, UPDATE, or DELETE statement, or an insert, update, or delete high level language statement in an application program
types of triggers.
• Before delete trigger
• Before insert trigger
• Before update trigger
• After delete trigger
• After insert trigger
• After update trigger
• Read only trigger (external trigger only)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a buffer in memory?
List down the data types in the db2 database.
What is reorg and runstats in db2?
How do you pull up a query which was previously saved in qmf?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What happens in bind step in a db2 program?
What is db2 connect?
How do I delete a table in database?
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
What is a db2 cursor?
How to find the number of rows in db2 tables?
Name the lockable units in DB2?
Where do you specify them?
what is the responsibility of the construction superintendent
What is drop table?
