search cancel

Difference between HASHLOV and HASHLOV1

book

Article ID: 258110

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

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

Environment

Release : 4.10

Resolution

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 - Seedlist name taken from the Scramble database. (GTSRC_REFERENCE_LOV or GTSRC_REFERENCE_LOV1.RL_REF_ID)

  • Parm2 - Field name used to restrict the seedlist 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 seedlist 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.

It's always your choice on which masking function and which table/seedlist 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.