what is a trigger and types of triggers
- 3 Answers
- 8206 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 is iseries database?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
Define data page.
What is the role of the data page in the db2 database?
Define db2.
where can we use index and subscript ? with example ?
How do I copy a table in db2?
What are db2 tables?
How will you return the number of records in table?
Can you tell me how can you find out the # of rows updated after an update statement?
how to resolve -811
COBOL 
