REP008 - Virtual Fields

A virtual field is a field which appears as part of a file but does not actually exist in the physical database file. Its value is dynamically derived based on the fields in the file. Virtual fields provide flexibility, since you can combine or extract data from fields in a file and extend the information already contained in the file.

Objectives:

  • To explain virtual fields.
  • To highlight the different types of virtual fields that can be defined using the LANSA Repository.
  • To achieve these objectives, you will complete the following:

    Step 1. Add Virtual Fields to Employee File

    Step 2. Calculation Virtual Field

    Step 3. Concatenation Virtual Field

    Step 4. Code Fragment Virtual Field

    Step 5. Create Test Form

    Summary

    Before you Begin

    In order to complete this exercise, you must have completed the previous exercises.