13.6 Handling Relative Record Numbers

Under the IBM i, when a record is added to a database file, it is automatically allocated a unique relative record number.

This number can be used for the fast access of records when the relative record number is known.

A record's relative record number may also change when a database file is reorganized.

No user intervention is required for any of this to happen.

Visual LANSA does not have the same concept of relative record numbers as the IBM i database.

Under Visual LANSA, this automatic allocation of a relative record number must be "emulated". The emulation of relative record numbers will allow your existing applications that use relative record numbers to execute without being changed.

You should be aware of the following:

There are two methods of assigning the relative record number.