Answer Posted / satty
trigger is a set of actions that will be executed or implemented , when a defined event occur. triggering events are 1.insert, 2.update, 3.delete
triggers can be defined for a specific table and once defined then it is automatically active.
triggers are used to do a data validation and to maintain data integrity.
types of triggers:
before trigger and an after trigger.
triggers information can be stored in the sysibm.systriggers
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is table space in db2?
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 ?
Define db2.
What is lock escalation in db2?
How do I delete a column in db2?
How do I change the column size in db2?
What is null in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Give the name of some fields form sqlca.
What is view db2?
List out the data types available.
Are view updateable?
i want to maintain uniqueness on pdf without make lf??????????
How many databases can be created inside an instance in db2 ?
How do I delete a table in db2?