Create Hash Source Value Access Path Definition

This access path definition specifies that the translate table can be accessed by a calculated hash value.

To create a Hash Source Value Access Path definition:

From the Resource Administration stack bar on the Data Privacy Menu, select Manage Translate Tables. The Manage Translate Tables view appears.
Select the desired translate table. Click the Access Paths' Add button and select Hash. The Hash Access Path dialog box appears.
Enter a Path Name or accept the default path name.
Specify whether to always use Key access for this path. Select key access only when the key of the translate table is a sequential number and every access is to read the translate table by key.
Optionally, select a user defined hash function from the Optional Custom Hash drop-down list.
Click OK. Your access path now appears in the Access Path list.

Related Topics