Mainframe, MVS and zOS Discussion

Hi,

I'm not sure what is a trigger in DB2 and where it is used?

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.

Trigger is a PL/SQL block that is executed on an event in the database. The event is related to a particular data manipulation of a table such as inserting, deleting or updating a row of a table or invoking a UDF ( User define function in DB2 )

Sometimes to keep a track of the changes in a table or to perform an automatical action or to perform an action depending on another action ( Dependency ) DB2 Developer use triggers.

Thanks,
Adyanath Ghosh

Thank you Anuj.

Thanks Adyanath - but your pdf directs to an Oracle document?

Prakash Jha wrote:Thanks Adyanath - but your pdf directs to an Oracle document?

Though the database is different but I think the concept is same...