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 the use of dclgen in db2?
Is db2 a mainframe database?
What is cobol db2?
What is the physical storage length of the data types: date, time, timestamp in the db2 database?
Why db2 is called db2?
What is the result of open cursor statement?
what is db2 restart?
What is rct?
How to execute stored procedure in db2 command editor?
How would you find out the total number of rows in a db2 table?
What is the difference between oracle and db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
How do I add a column in db2?
what is diffrence b/w file-aid tool and file-aid utility???
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
