[ 
|../../index.htm#lansa/reptut01_0485.htm]
You are here:
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 |
|
|
[ |../../index.htm#lansa/reptut01_0485.htm]