Masking during extract process
933968Jun 24 2012 — edited Jun 27 2012Hi,
When extract process is creating trail file, the column values are visible. Actually I want to mask particular column during extract process. I have used the following command to do it.
extract emask1
userid ggs, password *****
exttrail /home/ggs/replication/dirdat/mask/tt
wildcardresolve dynamic
TABLE GGS.emask1, SQLEXEC ( ID id1, QUERY "select id, 'ABCDEFGHIJKL'||substr(name,length(name)-3,4), &
city from ggs.emask1", NOPARAMS ) ;
ADD EXTRACT emask1, TRANLOG, BEGIN NOW
ADD EXTTRAIL /home/ggs/replication/dirdat/mask/tt, EXTRACT emask1, MEGABYTES 1
But still the column value is visible in trail file as it is. pls help.