Creating/Defining Your Data Model › Defining Your Data Model › Redirection of Qualifier Fields

Redirection of Qualifier Fields

A qualifier field is resolved from a Qualified by relation. Redirection of qualifier fields allows you to specify that a relation between two files is satisfied not by an exact match of values, but by the nearest match. The redirected field gives the search value.

This redirection is particularly useful when you deal with variables such as prices and discounts.

You can redirect entries arising from qualified fields to any other fields of the same attribute type that are present in the referencing file. For example, dates can be redirected to other dates, numbers to other numbers, and values to other values.

If the length of the overriding field is not the same as the redirected field, a truncated value is used.

For qualified redirection, a field that has been redirected is not dropped from the model file entry list or from the generated physical file.

You can use qualified redirection only on fields defined as qualified keys on the referenced file by means of a Qualified by relation.