[ |../../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]