Step 6. Create an Access Route and a Predetermined Join Field (PJF)
REP011 - Repository Summary
In this step create an access route from the Employee Holidays file to the Employee File. The number of records is 1.
1. Create a field for the employee surname to be used as a PJF as follows.
|
Field Name |
Field Description |
Type |
Length |
|
|
iiiSurnamePJF |
Employee Surname |
Alpha |
25 |
Allow LC |
2.Define an to the Employee file, with a key of iiiEmployNumber.
3. Define the to retrieve iiiSurnamePJF from the employee surname (iiiSurname) in the Employee file. This is a lookup PJF.
Remember to compile your file.