Having issue with Using Where condition for string fields in Masking rules for mainframe

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

 

We are working on adding masking rules to our requirement to mask PII data from IMS/flat file based Database. 

 

XVR_RECORD,,WHERE,XVR_E_RECORD_CONDITION = 19,,,,,,,,,,,,,

If the value of the field is other than 19, ignore the masking for the record

However when we use the  where clause in our masking rules file  , Masking routine does not mask the data.

Cause

If the field is a string , and it should be in ' '.  

Environment

Release : 5.4

Component : CA Test Data Manager - Others

Resolution

 

Given that the XVR_E_RECORD_CONDITION is a string, the value as shown below needs to be between quotes:

 

XVR_RECORD,,WHERE,XVR_E_RECORD_CONDITION = 19,,,,,,,,,,,,,

 

So that should be setup as XVR_RECORD,,WHERE,XVR_E_RECORD_CONDITION = ’19’ ,,,,,,,,,,,,,

 

If the field is a string, you need to place the value between quotes.