• Created by user-cd56b, last updated on May 14, 2022 1 minute read

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Next »

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

  • No labels