Virtual File Accessor Considerations

PROIV Documentation

Virtual File Accessor (VFA) Considerations

When using Virtual File Accessors (VFA), be aware of the following constraints that may impact data retrieval and behaviour:

Overlapping Keys and Unexpected Behaviour

Overlapping File Variables and Outer Joins
- If multiple constituent files share the same file variable, PROIV does not distinguish them like SQL does with table aliases.
- Further, the rules and file variable behaviour are described (see Virtual File Accessor File Variable Behaviour). so please read this before using overlapping file variable names.
Loss of Key Status in Overlapping Fields
- If a field is a key in one file but overlaps with a non-key in a later file, it will be treated as a non-key in the VFA.
- This can affect sorting, indexing, and data retrieval performance.
- Workaround: Consider renaming overlapping fields in later files or restructuring file definitions.

Always check how overlapping keys affect joins and indexing in your VFA setup.
If retaining key status is important, adjust file structures to avoid conflicts.
If outer joins are involved, test whether shared variables behave as expected across files.