REP005 - Create Tables

A LANSA table may also be referred to as a database table. Table columns are defined by adding fields to the table. Once a table is compiled, the records in it can be retrieved, added, updated and deleted.
Objectives

• To create two table definitions. You will create a Department Table and an Employee Table.
• To review the database table attributes which can be defined in the LANSA Repository.

• The table definitions will be as follows:

  Department Table       iiiDepartments	Employee Table       iiiEmployees
  iiiDeptCode** iiiDeptDescription	iiiEmployNumber** iiiDeptCode iiiSurname iiiGivenName iiiSalary iiiStartDate iiiEmployNotes	indicates the table key field

  Note: Tables can be created manually or by copying an existing table definition in the LANSA Repository. In this lesson, you will manually create the table definitions so that you can see all the steps involved. If you copy an existing LANSA table definition, the table columns, rules, and all other related database information about the table can be copied.
  To achieve these objectives, you will complete the following:
  Step 1. Create Table Definition
  Step 2. Compile the Table
  Step 3. Create Department Maintenance Form
  Step 4. Execute Department Maintenance Form
  Step 5. Create the Employee Table
  Step 6. Create Employee Maintenance Form
  Step 7. Execute Employee Maintenance Form
  Step 8. Database Attributes
  Summary

  Before you Begin
  In order to complete this exercise, you should have completed the previous exercises.