What is TRIGGER in DB2

IBM's flagship relational database management system
Post Reply Previous topicNext topic
vasanthamugi
Posts: 14
Joined: Thu Dec 20, 2007 2:38 pm
Skillset: mainframe skills: jcl,vsam,cobol,db2,cics
Referer: ibmmainframes.com

What is TRIGGER in DB2

Postby vasanthamugi » Fri Dec 21, 2007 11:35 am

what is a trigger?where it is used?
vasanthamugi
Top
rpuhlman
Posts: 1
Joined: Thu Dec 06, 2007 10:51 pm
Skillset: COBOL (74 thru current), CICS, DB2, IMS DLI (Command Level), IMS DB/DC, VSAM, TOTAL, RAMIS, JCL, TSO, ISPF, FILEAID, DATA EXPERT, DITTO, OS Utilities, Endevor, Changeman, XPEDITER, SMARTTEST, INTERTEST .... etc ...
Referer: The other forum

Re: What is TRIGGER in DB2

Postby rpuhlman » Fri Dec 21, 2007 11:15 pm

A trigger is a set of instructions that are executed after a DB2 action, such as INSERT, UPDATE or DELETE, on a particular table. You would use the CREATE TRIGGER statement to build your trigger for a particular table.
Top
Post Reply Previous topicNext topic
  • Similar Topics
    Replies
    Views
    Last post

Return to “DB2”