Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is a trigger and types of triggers

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1133


What is cobol db2?

999


Is ibm db2 open source?

1075


Highlight all the advantages that are attached to a package.

1119


How to find the number of rows in db2 tables?

1071


What is dbrm? What it contains? When it will be created?

1049


Define declaration generator (dclgen).

1114


What is runstats utility in db2?

1018


How to check table size in db2 sap?

1038


Define sqlca.

1108


what is a corelated subquerry?

1122


Explain various types of locks in db2?

1150


How connect db2 database to datastage?

1241


How many databases can be created inside an instance in db2 ?

1035


How do I connect my db2 database to ibm?

1050