REP011 Repository Summary

REP011 - Repository Summary

Objectives

• To use the knowledge you have acquired in the previous tutorials to create LANSA fields and a file with validation rules, virtual fields, PJFs and a logical view.

     The file you will create will be called Employee Holidays iiiEmpHolidays (where iii=your initials) with the following fields:

iiiEmployNumber	Existing employee number field
iiiHolCode	Holiday Code
iiiHolStartDate	Holiday Start Date	Showtime = False
iiiHolEndDate	Holiday End Date	Showtime = False
iiiHolComments	Holiday Comments	Allow lower case
iiiHolDuration	Holiday Duration (virtual field)	Edit Mask = 2
iiiSurnamePJF	Employee Surname (PJF from the employee file)

• To create an application to maintain the file and another application to use the logical view to search the file.

To achieve these objectives, you will complete the following:

Step 1. Create the File Definition

Step 2. Modify Field Definitions

Step 3. Add Rules to the File

Step 4. Create and Execute a Test Form

Step 5. Add a Virtual Field to Your File

Step 6. Create an Access Route and a Predetermined Join Field (PJF)

Step 7. Recreate Employee Holidays Application

Step 8. Create a Logical View and Test

Summary

Some Helpful Tips

• If you need additional help completing any of the steps, refer back to the exercises in the appropriate lessons.

• Remember to use the online Help and the LANSA documentation.