Interested to Buy Any Domain ? << Click Here >> for more details...
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 meant by dclgen?
Explain the benefits you can get from mainframe connect?
How many databases are there?
What is buffer pool in the db2 database?
What is cursor with hold option in db2?
How is a typical db2 batch pgm executed?
What is db2 look?
How can you quickly find out the # of rows updated after an update statement?
What are the uses of db2 optimizer?
B37 abend during spufi?
What is netezza database?
How is deadlock resolved?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
How would the varchar column remarks defined?
