Derive value when record is read
Specify whether the virtual field should be derived from the file after reading the real field.
This option means that the virtual field is created when you read the information from the file. The information will now be derived and available for display. For example, a date is stored as format YYYY/MM/DD so the file can be properly sorted by date, but the information is displayed to the user as DD/MM/YY.
Default=NO (unchecked).
Rules
- At least one of Populate real field when writing to file and Derive value when record is read must be selected. Both values may be selected.
Tips & Techniques
- Virtual field derivation is also performed relative to predetermined joined fields. Refer to 3.5.1 Access Route Definitions and Derivation.
Also See