what is a trigger and types of triggers

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


Please Help Members By Posting Answers For Below Questions

What is the reason behind not using select * in embedded sql programs?

877


What is the role of schema in the db2 database?

948


what is diffrence b/w file-aid tool and file-aid utility???

4570


Why do we use cursor?

855


What is the information associated with sysibm.syslinks table?

903


How does cobol compile db2 program?

842


What is a db2 schema?

1016


What is the maximum size of varchar data type in db2?

895


How do you simulate the explain of an embedded sql statement in spufi/qmf?

873


What is the use of value function?

879


Is ibm db2 open source?

859


What does db2 plan contain?

790


Explain db2.

846


What is ibm db2 client?

719


B37 abend during spufi?

1243