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

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.

2.Define an Access Route to the Employee file, with a key of iiiEmployNumber.

3.  Define the Predetermined Join Field to retrieve iiiSurnamePJF from the employee surname (iiiSurname) in the Employee file. This is a lookup PJF.

     Remember to compile your file.