Step 4 Create Fields in the LANSA Repository

Step 4. Create Fields in the LANSA Repository

REP009 - Access Routes and PJFs

In order to add a Predetermined Join Field to a file definition, the field has to first be defined in the Repository. In this step you will create two field definitions which you will use when creating your Predetermined Join Fields.

1.  Create two fields called iiiTotalSalaryPJF and iiiDeptDescPJF. The iiiTotalSalaryPJF field will contain the total value based on the iiiSalary field. The iiiDeptDescPJF field will hold the Department Description based on the iiiDeptDescription field.

2.  In the most efficient means possible, create the following fields with the basic characteristics listed below. (Reminder: iii=your initials.)

Field name: iiiDeptDescPJF Description: Department Description Type: Alpha Length: 20

 

Field name: iiiTotalSalaryPJF Description: Total Salaries Type: Packed Length: 11 Decimals: 2 Edit mask: A