Sequential Access Path

The sequential row selection access path chooses replacement rows from the translate table by returning the rows sequentially.

Sequential access can fail only when the rule action requests unique row retrieval. Without unique row retrieval, access will start at the beginning of the translate table until the end of the table is reached. Then it will restart at the beginning of the table to return the rows sequentially.

When unique row retrieval is requested, each row will be returned only once. If the end of the translate table is reached, disguise will fail and the disguise failed action defined for the translate table will be taken.

Sequential access is not repeatable and not reversible.

If Unique row retrieval is selected, the values are unique only if the values in the translate table are unique.

Sequential Access Path has no options.

For information on how to use a sequential access path in a rule, see Translation-Rule-Actions-Sequential-Access-Path. For information on how to create a sequential access path, see Create-Sequential-Access-Path-Definition.