Implementing Triggers, UDTs, UDFs and Constraint Rules
 

This 1 day course presents:

the design, coding and administration requirements to implement, develop and test data integrity and business rules for the DB2 UDB for z/OS and OS/390 Environment using the most current version 6 enhancements. With the addition of Triggers, User Defined Distinct (Data) Types and User Defined Functions the degree of integrity support within the DBMS has greatly increased. These enhancements, when properly implemented, can result in faster application development and easier maintenance by moving certain parts of the application logic into DB2. Join us as we explore automating and controlling when events occur through the use of Triggers, enhancing integrity through UDTs/UDFs and putting your DBMS to work to support your overall business rules.

Topics Covered:

• Planning for Data Integrity
• Introduction to Triggers
• Complex Triggers that perform Actions or use Logic Trigger
• Performance

Duration: 1 day

Delivery: Class Lecture

Audience: 

DBAs and Application Developers who will design, develop and implement Data Integrity and Business Rules in the DB2 UDB for z/OS and OS/390 environment.

Outline:

1. Planning for Data Integrity

 Integrity Choices
 Referential Integrity
 Table Check Constraints
 Triggers
 User Defined Distinct Types and Functions
 How it all fits together

2. Introduction to Triggers

 Triggers Defined
 Parts of a Trigger
 Types of Triggers
 Creating & Dropping Triggers
 Coding Rules
 Trigger Package

3. Complex Triggers

 Triggers that invoke UDFs
 Triggers that Call Stored Procedures
 Transition Tables
 Trigger Cascading
 Error Handling
 Debugging

4. Trigger Performance Considerations

 Transition variables
 Transition tables
 Row vs. Statement Triggers
 Coding Considerations
 Trigger Overhead