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.