When we use options "Substr start" and "Substr length" with FORMATFPE1EXT on a NUMERIC fields on mainframe, the result was not good.
Masking function on Windows
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 Occurrence,To Occurrence,Parm5,Parm6,Parm7,Parm8,Parm9,Parm10 DB_TEST_FM,NEQ_STR,FORMATFPE1EXT,EXT:DESJ-SS:TAG_NEC_NEQ$HEXA$FOLDER=FPE,NNNYN,,,Y,,,,,,3,7,,,,N,,,,,,,,, DB_TEST_FM,NEQ_INT,FORMATFPE1EXT,EXT:DESJ-SS:TAG_NEC_NEQ$HEXA$FOLDER=FPE,NNNYN,,,Y,,,,,,3,7,,,,N,,,,,,,,, |
Masking function on MainfraME
"Table","Column","Function","Parm1","Parm2","Parm3","Parm4","KeepNulls","Dateformat","Cross Reference","Override_Lookup", "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" TSTAUT0I,NO_NEQ_CHAR,FORMATFPE1EXT,"SDS.G51.TAG.NEC.NEQ",NNNYN,,,Y,,,,,,3,7,,,,N,,,,,,,,, TSTAUT0I,NO_NEQ_NUM,FORMATFPE1EXT,"SDS.G51.TAG.NEC.NEQ",NNNYN,,,Y,,,,,,3,7,,,,N,,,,,,,,, |
Fields NEQ_STR and NO_NEQ_CHAR are CHAR (first column)
Fields NEQ_INT and NO_NEQ_NUM are NUMERIC/INTEGER (second column)
Original Value
1176104207;1176104207 3312345930;3312345930 8812345781;8812345781 1112345752;1112345752 1112346261;1112346261 8812345840;8812345840 1234567890;1234567890 |
Windows masking result
1176289313;1176289313 3310309219;3310309219 8811908589;8811908589 1114736946;1114736946 1119984129;1119984129 8810519841;8810519841 1238785689;1238785689 |
Mainframe masking result
1176289313;0076104207 3310309219;0072345930 8811908589;0072345781 1114736946;0072345752 1119984129;0072346261 8810519841;0072345840 1238785689;0074567890 |
Release : 4.10
Component : Mainframe
Working as designed.