what is a trigger and types of triggers
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 |
Plan has the optimized access path in it. But is that optimized access path is attained or known
what happend with out using Commit,when closing cursor and program?
explain about index with examples
Explain about mirror activator disk mirroring?
What is dbrm? What it contains? When it will be created?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What is sqlca’s maximum length?
What is page size in db2?
Can SQL statements/queries be included in a copybook?
When reorg is used?
What does DML stand for and what are some examples of it?
What is dbrm library?