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.

  • No labels