REP007 - Table Validation Rules/Triggers

Application business rules are centrally defined in the LANSA repository as validation rules either in the field or the table definition. Centralized field validations remove the need for developers to code the same validation into each program that uses the table.  A rule is checked when a database table operation (such as an insert, update or delete) is performed.

Objectives:

• To highlight the difference between field and table level validation rules and the hierarchy which exists between these rules.

• To show how multiple rules can be defined for a field.

• To add the following business rules to table iiiDepartments:

iiiDeptCode Must be in range A to ZZZ

• To add the following business rules to table iiiEmployees:

iiiDeptCode iiiDeptCode must exist in table iiiDepartments iiiSalary Must be less than 10000.00

To achieve these objectives, you will complete the following:

Step 1. Add a Rule to Table iiiDepartments

Step 2. Recompile the Table and Test Department Rules

Step 3. Referential Integrity Rule in iiiEmployees Table

Step 4. Add Rules to iiiSalary Field

Step 5. Recompile the Table and Test Employee Rules

Step 6. Complete Referential Integrity

Step 7. Review Table Level Triggers

Summary

Before you Begin

In order to complete this exercise, you must have completed the previous exercises.