Keep Last
Specify the number of retrieved Predetermined Join Field values to be kept in memory.
This value applies to Predetermined Join Fields defined on the access route when the relationship is one to one. (Refer to Maximum Records.) Each value retrieved from the accessed file is stored in memory up to the keep last value.
Rules
- Range of values is 0 to 999.
- A value can only be entered if the access route relationship is one to many, i.e. the Maximum Records is set to One.
Tips & Techniques
- This is a very useful feature when using Predetermined Join Fields to retrieve values from small frequently used code fields to reduce I/Os.
- By storing values in memory, file accesses can be reduced and performance is improved. If more than the keep last value are retrieved, then a file access is simply performed and the current values are overwritten starting from the first value retrieved.
Also See