Interested to Buy Any Domain ? << Click Here >> for more details...
what is a trigger and types of triggers
- 3 Answers
- 8942 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 type of database is db2?
how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example
What is a cursor?
i have a db2 variable how do u declare tht into working storage section ?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
Explain about cursor stability?
What is the role of union all and union
what is a corelated subquerry?
How to find primary key of a table in db2?
how to resolve -805. give clear explination for that
Normalization in DB2 – first normal form, second normal form
What is bind in db2?
COBOL 
