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:

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.