Rexx Program to do data masking



IBM's Command List programming language & Restructured Extended Executor

Rexx Program to do data masking

Postby cooldude14344 » Tue Mar 08, 2011 12:01 am

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
cooldude14344
 
Posts: 19
Joined: Sat Mar 05, 2011 1:25 am
Has thanked: 0 time
Been thanked: 0 time

Re: Rexx Program to do data masking

 

Re: Rexx Program to do data masking

Postby NicC » Tue Mar 08, 2011 12:56 am

TRANSLATE(’APQRV’,XRANGE(’00’X,’Q’)) -> ’APQ ’
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Rexx Program to do data masking

Postby prino » Tue Mar 08, 2011 1:13 am

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...
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
prino
 
Posts: 536
Joined: Wed Mar 11, 2009 12:22 am
Location: Oostende, Belgium
Has thanked: 3 times
Been thanked: 21 times

Re: Rexx Program to do data masking

Postby cooldude14344 » Tue Mar 08, 2011 1:52 pm

Another day,another useless reply from some pretend to be know everything someone......get a life
cooldude14344
 
Posts: 19
Joined: Sat Mar 05, 2011 1:25 am
Has thanked: 0 time
Been thanked: 0 time

Re: Rexx Program to do data masking

Postby enrico-sorichetti » Tue Mar 08, 2011 3:59 pm

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2643
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: Rexx Program to do data masking

Postby cooldude14344 » Tue Mar 08, 2011 9:08 pm

not much help anyway
cooldude14344
 
Posts: 19
Joined: Sat Mar 05, 2011 1:25 am
Has thanked: 0 time
Been thanked: 0 time

Re: Rexx Program to do data masking

Postby enrico-sorichetti » Wed Mar 09, 2011 1:39 am

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
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2643
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times


Return to CLIST & REXX

 


  • Related topics
    Replies
    Views
    Last post