Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

[ Image Removed |../../index.htm#lansa/reptut01_0485.htm]
You are here:

...

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

     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

 

...