Hi,
How exclude and ignore comma (,) and double quote (") when we mask data with GTXMSK on mainframe.
For example:
Table,Column,Function,Parm1,Parm2,Parm3,Parm4,Keep Nulls,Date Format,Cross Reference,Override SQL,Unique Columns,XPath Element,Substr start,Substr length,Notes,Preformat,Update,Use Masked Values,Restart Column,From Occurance,To Occurance,Parm5,Parm6,Parm7,Parm8,Parm9,Parm10
TEST_CLASSIFIER,EMAIL,FORMATENCRYPT1,,,,,Y,,,,,,,,Encrypt Email,,,,,,,1234AbCde45678FgHiJk,!#$%&'()*+-./:;<=>[email protected][]_{|}~¡¢£¤¥¦§¨©ª«¬®¯°±²³µ¶·¸¹º»¼½¾¿ÐרÞßð÷ø^´`\þ,ÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖÙÚÛÜÝÿàáâãäåæçèéêëìíîïñòóôõöùúûüý!#$%&'()*+-./:;<=>[email protected][]_{|}~¡¢£¤¥¦§¨©ª«¬®¯°±²³µ¶·¸¹º»¼½¾¿ÐרÞßð÷ø^´`\þ,,,
I can't put comma (,) into the parm5 and parm6 because that will indicate the end of the parm!
When I had double quote (") into the parm5 and parm6,the result of the masking was too different.
Is there a escape character on the mainframe?
Release : 4.9
Component : TDM ACTION SERVICE
The only way to ignore and exclude comma(,) and double quote (“) on the mainframe is to use :
FORMATENCRYPT1IGNORESPECIALCHARS=Y
FORMATENCRYPT1EXCLUDESPECIALCHARS=Y