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

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

book

Article ID: 249534

calendar_today

Updated On:

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?