Step 1. Create the Table Definition

In this step, you will create an employee holiday table which will contain the details of the employees' holidays.

1.  Create a LANSA table Name iiiEmpHolidays, Description Employee Holidays. Make it RDMLX enabled.

2.  Using the Multi-Add Columns option in the table, add these real columns to the table:

     Don't forget to define the table keys.

iiiEmpHolidays Employee Holiday Table Type Length Key iiiEmployNumber Employee number Alpha 2 1 iiiHolCode Holiday Code Alpha 3 2 iiiHolStartDate Holiday Start Date DateTime 26   iiiHolEndDate Holiday End Date DateTime 26   iiiHolComments Holiday Comments String 512