Join | Login | Why Join?   
SQL Server, Oracle, DB2, Sybase, MySQL Help - SSWUG.ORG HACKER SAFE certified sites prevent over 99.9% of hacker crime.
Search SSWUG:   
 
Access to 591 free guest articles, discussions and more, just create your free SSWUG User ID:
Email address:  
This will be your login ID - we'll email you your password - you'll even receive the newsletter, opt-out at any time.
Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

Full site membership is required for this article. Already a full member? Login here.
You currently have a guest membership. You can upgrade to full site membership here (free trial available).

An Overview of Triggers in DB2 for OS/390 and z/OS


 Article Abstract:

(Craig Mullins) Most SQL database management systems provide support for triggers. IBM added trigger support to DB2 for OS/390 in Version 6.

A trigger is a piece of code that is executed in response to a data modification statement; that is, an insert, update, or delete. To be a bit more precise: triggers are event-driven specialized procedures that are stored in, and managed by the RDBMS. Each trigger is attached to a single, specified table. Triggers can be thought of as an advanced form of "rule" or "constraint" written using an extended form of SQL. A trigger can not be directly called or executed; it is automatically executed (or "fired") by the RDBMS as the result of an action - a data modification to the associated table.

This article describes the trigger support available on mainframe DB2.

 Read this article...
 Related Articles - For Members.
All Articles By Author

Tips for using SQL Server 2005 triggers
Getting Started with Triggers
SQL Triggers and Other Trigger Enhancements in V5
SQL SERVER 2005 Disable Triggers - Drop Triggers
SQL Server Triggers Optimization Tips
Stored Procedures, Triggers and User Defined Functions on DB2 Universal Database for iSeries
The Trigger-Happy DBA - System Triggers
The Trigger-Happy DBA - System Triggers



Key (Please note):
(R) - registration may be required for access at the target site
($) - target site may require paid membership for access to this or other content

No Comments/Feedback Posted Yet. Post Your Comments/Feedback

Email to Friend //  Discuss Article //  Rate Article //  Digg Article //  Add to Del.icio.us //  Add to Technorati

   



 

[ Register ] [ Webcasts ] [ Podcasts ] [ Newsletter Archive ] [ RSS/Feeds ]
[ About ] [ Advertise ] [ Contact ] [ Privacy ] [ Terms of Service ]
[ Link to SSWUG ] [ List Server Archives ] [ Recent Orig. Content ]
(c) 1997-2009, Bits on the Wire, Inc.  (0)

Some names and products covered by SSWUG are the registered trademarks of their respective owners.
DAA10354WWW004