"Substr start" and "Substr length" problem with FORMATFPE1EXT on mainframe

Products

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

Issue/Introduction

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

 

Environment

Release : 4.10

Component : Mainframe

Cause

Working as designed.

Resolution

After a further investigation, we concluded that we have never supported substring functionality for numeric fields on the mainframe. 

I know that FORMATFPE1EXT has its own parameters to have a functionality similar to substring. 

 

Can you use the parameters that are already supported?