Specify the number of retrieved Predetermined Join Column values to be kept in memory.
This value applies to Predetermined Join Columns defined on the access route when the relationship is one to one. (Refer to Maximum Records.) Each value retrieved from the accessed table is stored in memory up to the keep last value.
- 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 Columns to retrieve values from small frequently used code tables to reduce I/Os.
- By storing values in memory, table accesses can be reduced and performance is improved. If more than the keep last value are retrieved, then a table access is simply performed and the current values are overwritten starting from the first value retrieved.
Predetermined Join Column Development in the Developer Guide.