What about just using a where clause like fieldname like %SSN%. If you are just wanting to change the numbers you could then use the Translate function to change them.
where condition does not support like statement in GTMSKF program..... could you please share the example, so that i can do from my side.
Hello there. This is my fault. I somehow thought you were masking tables in a database. Apologies for the confusion. I tried using the "like" in a where clause for a file and it didn't work for me either. I will investigate a bit more because I thought I was able to do something like this for another customer.
Again my apologies for any inconvenience my original response may have caused.
Thanks for detailed explanation. AND and OR condition working fine... but i want to use substring in where statement. Please let me know if any other alternate ways to implement substring function in flat file masking.
Hello there. I checked with a few others and currently about the only option you have (and this dependents on how generic the location of SSN 123451234 is) is to subdivide the definitions in the copybook. If the ssn value can be anywhere in the field then this will not work either. I am not sure what else is contained in this field but what about just masking all numeric characters regardless if SSN is there or not. you can use the Translate function to do this.