Page 1 of 1

Rexx Program to do data masking

PostPosted: Tue Mar 08, 2011 12:01 am
by cooldude14344
Hi Friends,
My requirement is to mask the production data sensitive information like name,address.
I have around 150 production files each have the unique copybooks. I am intended to mask the sensitive information and write to the masked output in a seperate file. I would like to use the TRANSLATE funtion to mask the data.

The copybook got many fields , but i would want to TRANSLATE only the sensitive information and write to output file along with other fields. could you please give an sample rexx command.

Cheers
R

Re: Rexx Program to do data masking

PostPosted: Tue Mar 08, 2011 12:56 am
by NicC
TRANSLATE(’APQRV’,XRANGE(’00’X,’Q’)) -> ’APQ ’

Re: Rexx Program to do data masking

PostPosted: Tue Mar 08, 2011 1:13 am
by prino
cooldude14344 wrote:My requirement is to mask the production data sensitive information like name,address.
I have around 150 production files each have the unique copybooks. I am intended to mask the sensitive information and write to the masked output in a seperate file. I would like to use the TRANSLATE funtion to mask the data.

The copybook got many fields , but i would want to TRANSLATE only the sensitive information and write to output file along with other fields. could you please give an sample rexx command.

Another day, another very uncool dude trying to use REXX for something that it is totally unsuited for...

Re: Rexx Program to do data masking

PostPosted: Tue Mar 08, 2011 1:52 pm
by cooldude14344
Another day,another useless reply from some pretend to be know everything someone......get a life

Re: Rexx Program to do data masking

PostPosted: Tue Mar 08, 2011 3:59 pm
by enrico-sorichetti
another day another topic posted because of incompetent people setting requirements and assigning tasks :D

since I do not have the desire to retype the whole lot of suggestions and concerns
see
http://ibmmainframes.com/about43576.html

for a more complete discussion of data masking

and why You should not do it on your own, even worse with a REXX script

Re: Rexx Program to do data masking

PostPosted: Tue Mar 08, 2011 9:08 pm
by cooldude14344
not much help anyway

Re: Rexx Program to do data masking

PostPosted: Wed Mar 09, 2011 1:39 am
by enrico-sorichetti
replying on forums is..
on voluntary base
on our own time
free of charge
interest in the issue being debated
and last but most important the person asking should have the intelligence to accept what he/she is being told
instead of complaining that he/she did not get what he/she was expecting

in this case the issue is not interesting because more important aspects are disregarded/ignores

the answers I gave in the link I referred to are based on real experience ( seen it, done it) with real legal staff involvement
that' why I gave the reasonable forum advice of not doing it in house with naive algorithms.

too often the lack of understanding by people seeking answers is amazing
people being concerned just with low level technicalities disregarding more important organizational issues
seems that giving good advice on forums is like feeding caviar to pigs :D