Answer Posted / 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 |
Post New Answer View All Answers
What is the use of dclgen in db2?
How will you return the number of records in table?
What are the contents of dclgen?
What is bind in db2?
What are types of indexes?
What types of tables are there in the db2 database?
List down the data types in the db2 database.
What is dbrm? When it will be created?
Where can you declare a cursor in a cobol-db2 program?
Why select is not preferred in embedded sql programs?
What r the comman abends in db2, jcl and cobol???????
What is cloudant database?
Define check constraint.
What is the difference between cursor and select statement?
How do we specify index to include or not during bind process.