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
Before you Begin
In order to complete this exercise, you must have completed the previous exercises.