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
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
can all users have the privilage to use the sql statement select * (dml)?
What is the information associated with sysibm.syslinks table?
What is a page in db2?
What is check constraint in db2?
What does sqlcabc has?
What is package in db2 mainframe?
What is query_cache_limit?
Discuss about db2 bind?
How do I start db2 in windows?
What is clone table?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Is db2 free?
How to restart a DB2 program?
What are host variables in db2?