Mask Table data

15 pts.
I have a requirement, where I have to mask the emp details,as the confidential data are stored in our data base file as differently than actual name foe e.g. EMP TEST1 ,ADDRESS TEST2 NOW my requirement in details as follows I have emp data in following files 1.TAB1 - MR EMP TEST 1 MRS EMT TEST02 like ... TAB2 - Here the data is spilted FIELD 1 - MR ADDRES LINE1 - EMP ADRESS LINE 2 - TEST 01 Now the data are very large and I need to an algorithm to (RPG program format) to mask the data,where there is any numeric before it FTP to other system. e.g EMP TEST 01 - the 01 need to replaced by some other string like 'A' or the entire line change to EMP TEST A. Thanks in advance Regards Sam

Software/Hardware used:

Answer Wiki

Thanks. We'll let you know when a new response is added.

Have you looking into encryption?
Depending on what release level you are on, there is some encryption methods that is now part of the iSeries.
Another option is to purchase a software package.
We handle credit card information so we must encrypt and use masking to meet PCI requirementrs.
We use Crypto Complete from Linoma Software

Discuss This Question: 2  Replies

There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • TomLiotta
    If this is primarily for supplying test data, I'd probably just create a VIEW that replaced problem values with generated values. But I can't quite understand the relationship between TAB1 and TAB2. It looks as if TAB2 has each field from TAB1 split onto a separate line. Is TAB2 the file that is going to be copied or masked? What creates the records in TAB2? Tom
    125,585 pointsBadges:
  • Mac0627
    Hi Charlie/Tom , Thanks a lot for suggestion,What I need /thing now is some way to gene rate random character ,that i will replaced with the Table data.Also the volume of table data is huge, we need this for production environment testing so I can`t repeat a character. The relationship between these 2 table is one is master table and the other one is details in spliced format that we are using some purpose. yes tom , this is for supplying test data, but testing in production env. Thanks in advance
    15 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.


Share this item with your network: