Hi,
You have to write LUA something like this:
function cm_transform()
oldvalue = source.column.getvalue()
mask_parms = "lookup masking parameters"
newvalue = optimmask(oldvalue, mask_parms)
if newvalue is NULL
newvalue = Sequence(12345, 1)
end
target.column.setvalue(newvalue)
end
------------------------------
Thanks,
Tulasi
------------------------------
Original Message:
Sent: 10-03-2018 19:59
From: Raja shekar Kanukanti
Subject: Sequence logic in LUA
Hi ,
Am looking for Masking function for Sequence in LUA in DB2.
Scenario :
If SSN_NO in TAB_A matches with SSN_NO TAB_B Then Apply lookup function else Apply Sequence.
Example : Sequence ( 12345,1)
Start with 12345 and Increment by 1.
------------------------------
Raja shekar Kanukanti
------------------------------
#InfoSphereOptim
#Optim