Interested to Buy Any Domain ? << Click Here >> for more details...
what is a trigger and types of triggers
- 3 Answers
- 9149 Views
- HSBC, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What are db2 objects?
How to compare data between two tables in db2?
What are the contents of a DCLGEN?
Can we install 2 different versions of Db2 on same mainframe?
How to handle null values in db2
When Can you be sure that a query will return only one row?
cursor with hold explain ?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
What is meant by AUTO COMMIT?
What will the COMMIT accomplish?
What is null indicator in cobol db2?
Explain in brief how does db2 determine what lock-size to use?
COBOL 
