Hello Optim users,
Does anyone had to mask information inside xml data type columns? Is there any supported way to do it, any hack or workaround?
Pinned topic Masking sensitive information in a DB2 XML column
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-06-11T08:37:51Z at 2012-06-11T08:37:51Z by SystemAdmin
Ducatiman 27000213JK58 Posts
Re: Masking sensitive information in a DB2 XML column2012-06-08T15:42:58ZThis is the accepted answer. This is the accepted answer.I ran into this a long time ago.
I output the xml elements to a flat file and loaded temporarily into a staging table and finally pointed Optim to the temp table and masked the elements. I then put the elements back into the XML column.
I did this for 2 million xml docs.
It went faster than it sounds
I leveraged Column Map Procedures.
There may be an easier way these days.