Difference between HASHLOV and HASHLOV1
search cancel

Difference between HASHLOV and HASHLOV1


Article ID: 258110


Updated On:


CA Test Data Manager (Data Finder / Grid Tools)


What is the difference between the GTSRC_REFERNCE_LOV and GTSRC_REFERENCE_LOV1 tables, as well as the HASLOV and HASLOV1 Functions?


Release : 4.10


The differences between the GTSRC_REFERNCE_LOV and GTSRC_REFERENCE_LOV1 tables in the Scramble database. Below is the explanation provided:

With the GTSRC_REFERENCE_LOV table, there were inconsistencies across databases and Mainframe masking.  So, Engineering developed the GTSRC_REFERENCE_LOV1 table and the HASKLOV1 masking function to correct these inconsistencies. We now have consistency across all DBs and MF using HASHLOV1.

Another difference, HASHLOV1 allows you to use many buckets to mask, whereas HASHLOV uses one big bucket. HASHLOV1also has an additional parameter, that provides more flexibility:

  • Parm1 - Seed list name taken from the Scramble database. (GTSRC_REFERENCE_LOV or GTSRC_REFERENCE_LOV1.RL_REF_ID)

  • Parm2 - Field name used to restrict the seed list rows to those where GTSRC_REFERENCE_LOV or GTSRC_REFERENCE_LOV1.RL_REF_VALUE matches the value in the given table. This parameter is not in the HASHLOV function.

  • Parm3 - Integer between 1 and 30 (default 1). This identifies which column of data (RL_REF_VALUE to RL_REF_VALUE30) is to be returned. This tells the masking engine which column from the seed list to pull the data from.

  • Parm4 - Field name containing the value to be hashed, or a reference to a cross-reference table to give the value to hash. Default is the field to be masked.

  • Parm5 - Seed Column Bucket stores the column number of the seed bucket that you want to use. For example, in pre-4.9 FDM releases, your Seed column bucket would be the first column of the seed list you are using. So if you wanted to mask cities in States, you would need to create a seed list where the state column would be the first seed column. Now you can define any column you wish to use as your Column bucket by entering the column number in Parm5.

    Each bucket list is based on a restricted value. If the specific value does not correspond to any bucket list, there will be an entry in the log indicating the value was not found (No match found for value XXXXXXX ). We will then look for the default value, and it does not exist (No default value for seed list:YYYYYY). As a result, we will leave the entry unmasked.

It's always your choice on which masking function and which table/seed list you want to use for what you're trying to accomplish. 


Additional Information

For more information, see TDM Masking Functions and Parameter for details regarding the masking functions.