|
View previous topic :: View next topic
|
| Author |
Message |
jayaprasad
New User
Joined: 25 Feb 2009
Posts: 2
Location: Bangalore
|
|
|
|
Hi,
We have a below scenario for data masking name filed.
1) John$Doe to be changed to Adam$Sam
2) -John Doe to be changed -Adam Sam
We need few built in functions which can be used to mask a part of name before the special char or either side of the special character.
Currently we are trying to do it uing an EXIT module, but want to avoid writing exit module.
Please suggest an alternative. |
|
| Back to top |
|
 |
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
Why do you think this is a db2 topic?
What is "IBM Optim"?
You will probably have to write something because external files will also need the same "masking". . . |
|
| Back to top |
|
|
jayaprasad
New User
Joined: 25 Feb 2009
Posts: 2
Location: Bangalore
|
|
|
|
I posted it under DB2 since I need to mask the data on DB2 tables.
IBM Optim is kinda ETL tool which helps in doing data masking. |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Follow on:
Do NOT multi-post the same question in multiple topics.
The duplicate has been removed.
If you want this moved to some other part of the forum, post this in a reply and your topic will be relocated. |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
why not read the product manual ???
asking questions on niche products rarely yields useful replies |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
| Quote: |
| IBM Optim is kinda ETL tool which helps in doing data masking. |
Specific to db2? What about vsam or sequential data that contains names?
The more info you provide, the better suggestions we can make.
I suspect that to get what you want, you will need to write code. Knowing what the product documentation says shoud surely help you. . . |
|
| Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009
Posts: 1788
Location: Bloomington, IL
|
|
|
|
| dick scherrer wrote: |
Hello,
| Quote: |
| IBM Optim is kinda ETL tool which helps in doing data masking. |
Specific to db2? What about vsam or sequential data that contains names? |
Knowing a little about Optim, I can say with assurance that it is not limited to working with DB2 sources (we are currently looking at using it with IMS), although its internal data are held in DB2 tables. |
|
| Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009
Posts: 1281
Location: Belgium
|
|
|
|
Optim is a suite of products
Optim move
Optim datastudio
optim database manager
optim performance manager
optim .. |
|
| Back to top |
|
|
daveporcelan
Active Member
Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania
|
|
|
|
IBM Optim does have data masking capabilities, but they cost extra.
We had the same situation as you, and chose to go the External Exit route.
This was easy to write in Cobol, and gave us the flexibility to do exactly what we wanted. |
|
| Back to top |
|
|
gkpabbati
New User
Joined: 25 May 2005
Posts: 3
Location: Hyderabad
|
|
|
|
Hi,
Can someone let me know more info on the usage of optim tool? SHare with me the e-manual or softcopy if any on this tool.
Thanks,
Gopala KP |
|
| Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK
|
|
|
|
| As it seems to be an IBM product the manual should be on the IBM website. Did you try googling for it. Loads of hits. Stop being lazy resurrcting old topics and do your own research. |
|
| Back to top |
|
|
|
|
