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.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define sqlca.

877


What is null in db2?

778


How to find primary key of a table in db2?

839


What is explain plan in db2?

800


Explain package in db2 and its advantages?

881


What is null indicator in db2?

875


Is it possible to create an Instance in DB2 using DB2 Control Center ?

869


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

870


What is coalesce in db2?

887


How will you return the number of records in table?

732


What parameters are used to control the free space in DB2?

860


How can you do the explain of a dynamic sql statement?

858


How can you quickly find out the # of rows updated after an update statement?

823


What is buffer pool in the db2 database?

874


What are iseries servers?

806