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.
Release : 5.4
Component : CA Test Data Manager - Others
If the field is a string , and it should be in ' '.
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.