View Source

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.