Random Access Path

The random row selection access path is used when the row number to select from the translate table is determined by calculating a random number at rule execution time. The random number is generated and the translate table row that corresponds with that number is returned as the replacement row.

Random access can fail when the rule action requests unique row retrieval and there are insufficient rows in the translate table. When unique row retrieval is requested, each row is returned only once. If all rows in the translate table have been returned, disguise will fail and the disguise action defined for the translate table will be taken. Without unique row retrieval, the same translate table row can be returned multiple times and will not cause the translation to fail.

Random 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.

Key access is the only option available for this access path. When key access is selected, the translate table must be keyed and the key of the translate table must be a sequential number. A random number will be calculated and a read issued for that specific row from the translate table.

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