Step 5 Add File Lookup PJF to Employee File

Step 5. Add File Lookup PJF to Employee File

REP009 - Access Routes and PJFs

In this step you will add a PJF for the Department Description field from the iiiDepartments Department file to the iiiEmployees Employee file. By defining a PJF (Predetermined Join Field) in the file, you can access the Department Description each time the Employee file is accessed without writing extra code to access the Department file. This field will appear as if it is simply part of the Employee file, and will be retrieved by the OAM.

1.  Open file iiiEmployees in the Editor.

2.  Ensure that the Fields in File tab is visible. Notice that no PJFs have been defined.

3.  Select the Access Routes tab to add your new predetermined join fields.

4.  Select the IIITODEPT access route. Use the Add button on the Home ribbon, and select Add PJF from the menu.

5.  Complete the Details tab, by enter the following characteristics:

 Use the ellipsis button and Find dialog to select each field.     

     Your Details tab will now look like this:

     The value of the iiiDeptDescription from the Department file will now be retrieved and returned to a LANSA program as the field iiiDeptDescPJF in the Employee file.

     Note: Predetermined Join Fields are display only fields.

     Your access route should now appear like this:

6.  Select the Fields in File tab. Your field list should now appear like this:

7.  Select the Select View Style button and change the display to Fields List View to get a different overview of your file:

     Your Fields in File tab will now look like this:

8.  Click the iiiDeptDescPJF field. Notice that it is possible to edit the PJF definition from the Fields in File tab.

9.  Compile the file and close it.