Data Modeling › Virtual Fields › Overview of Virtual Fields

Overview of Virtual Fields

A good database design eliminates redundancy; in other words, each item of data should be stored in only one place, rather than having multiple copies on different files. The i OS join logical file is a mechanism for building views that assemble data from different files.

In CA 2E you will use virtual fields to design such views. A virtual field is a field that is logically, but not physically, present on a file.CA 2E virtual fields are implemented through i OS join logical files.

Note that there are some limitations as to how virtual fields may be used in functions.