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 lock escalation in db2?
How to compare data between two tables in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
Why do we use cursor?
What does db2 mean?
What is the difference between plan and package in db2?
What is the use of dclgen in db2?
What language is db2 written in?
Is db2 a mainframe database?
How does coalesce work?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is dbrm?
What is host variable?
How do I connect my db2 database to ibm?
