CREATE CMPROC DEMO.TAMMY
  TEXT //'--LUA
'
'-- This script will mask the CUSTOMERS.CUSTNAME column depending On 
'
'-- the value In column City  
'
'--
'
'-- If City ="Los Angeles" mask CUSTNAME using Hashlookup For lastname (using CUSTNAME)
'
'-- If City ="Chico" mask CUSTNAME using a litteral "test test test" 
'
"-- If City =""Anaheim"" mask CUSTNAME using substr(CUSTNAME,1,4) || ""xxxx'
"
'
'
'	oldvalue = source.column.getvalue()
'
"	attr_type = source.column.getvalue('CITY')
"
'
'
"If attr_type == 'Los Angeles' then
"
'    mask_params = ''PRO=HASH_LOOKUP,LIB=DB2LUW,ID="PSTDEMO.OPTIM_IT_LASTNAME",''
'
"    mask_params = mask_params .. 'SOURCE=""CUSTNAME"",REPLACE=""LASTNAME"",HASHFLD=SEQ,'
"
'    mask_params = mask_params .. ''CONN=sample,USER=db2admin,PASS="db2admin",''
'
'    mask_params = mask_params .. ''FLDDEF1=(NAME="CUSTNAME",DATATYPE=WVARCHAR_SZ,LEN=20),''
'
'    mask_params = mask_params .. ''FLDDEF2=(NAME="LASTNAME",DATATYPE=WVARCHAR_SZ,LEN=20)''
'
'    newvalue = optimmask(oldvalue,mask_params)
'
'--
'
"elseif attr_type == 'Chico' then
"
'    newvalue = "test test test"
'
'--
'
"elseif attr_type == 'Anaheim' then
"
'    newvalue = String.sub(oldvalue,1,4).."xxxx"	
'
'--
'
'Else
'
'    newvalue = oldvalue
'
'End
'
'target.column.setvalue(newvalue)'// 
  ;