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 3.5.7 Maximum Records.) Each value retrieved from the accessed table 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 3.5.7 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.

Also See

Predetermined Join Column Development in the Developer Guide.
3.6.3 PJC Type