|
View previous topic :: View next topic
|
| Author |
Message |
noorkh
New User
Joined: 06 Mar 2006
Posts: 76
Location: Chennai
|
|
|
|
Hi,
I have below requirement. I have tried few options but it didn't work. Can you please help me out here.
Requirement:
Mask all Customer details while loading into UAT database.
Steps to do:
1. Unload data from production using BMC unload utility as below:
UNLOAD SHRLEVEL CHANGE UNICODE FORMAT BMCLOAD
SELECT * FROM table
Utility is: @BMCUNLD
2. Load them into UAT test tables using same utility.
I need to do data masking of customer details before i load them into UAT test tables.
Problem workout:
I can't change unload card and it has to be kept as it is. I can't change load card and it has to be kept as it is.
I need to build in between DFSOFT or COBOL process which will mask UNICODE STRING fields(VARCHAR, CHAR) into desired results. And resultant value should be UNICODE STRING only so that i can load them without any error.
I have tried building few DFSORT cards but nothing worked due to UNICODE conversion and also i am not sure how to convert particular values of a field to different values without affecting its UNICODE STRING format.
I want to do masking this way:
If customer name is NOOR then it should be converted to AIIH.
where N - A, O-I,O-I,R-H. And this should be conversion values.
Can you please through me some ideas? |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
from Your profile
| Quote: |
| Mainframe Skills: Reading History |
if instead of developing the skill of reading history
You had developed the one of reading the manuals,
You would not have had the need to ask  |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
Do you have a limited list of values to be "masked"? |
|
| Back to top |
|
|
sqlcode1
Active Member
Joined: 08 Apr 2010
Posts: 577
Location: USA
|
|
|
|
noorkh,
If I understood your requirement correctly, see if ALTSEQ works. I assume you have set of char. that needs to be converted to another set of char.
Thanks, |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
NOO way...
IIRC
VARCHAR columns are unloaded as <variable> fields (data length + data )
so defining the places where to carry on the <translation> might be impossible
the algorithm used is not that strong ,
if the organization is a Financial entity somebody might not be happy with such approximate masking
the powers in charge should investigate better |
|
| Back to top |
|
|
Skolusu
Senior Member
Joined: 07 Dec 2007
Posts: 2205
Location: San Jose
|
|
|
|
| noorkh wrote: |
I need to build in between DFSOFT or COBOL process which will mask UNICODE STRING fields(VARCHAR, CHAR) into desired results. And resultant value should be UNICODE STRING only so that i can load them without any error.
I have tried building few DFSORT cards but nothing worked due to UNICODE conversion and also i am not sure how to convert particular values of a field to different values without affecting its UNICODE STRING format.
I want to do masking this way:
If customer name is NOOR then it should be converted to AIIH.
where N - A, O-I,O-I,R-H. And this should be conversion values.
Can you please through me some ideas? |
Unicode string? Is it UTF-8 or UTF-16 ? What is the CCSID of the table in production and what is the CCSID of the codepage in Test? You planning to mask with EBCDIC characters? |
|
| Back to top |
|
|
|
|
