InfoSphere Optim

Hi, 

does any one have an example on how to call the optim.mask(with Optim Data Privacy LOOKUP) from LUA in Optim LUW?

Documentation is not quite clear, or perhaps i haven't found the right one :)

I want to send a variable as the source value and get it back as variable.
Then i will do some more concatenation before setting the column value for the target.

I want to use it direct from Optim classic by putting it in to a column map procedure.
(We don't have the designer installed) I have manage to execute LUA code this way by exporting the column map procedure, edit the script (Remove all capitals on reserved words like String etc) and then import it again.

best regards, 
Per

------------------------------
Per Wallqvist
------------------------------

#InfoSphereOptim
#Optim

​I have a failed example from a few years ago for masking a Brazil NID. Is commented out towards the end.

------------------------------
Ed Lipson
BNYMellon
Brooklyn NY
718 315 4763
------------------------------

Original Message:
Sent: 01-15-2019 02:48 PM
From: Per Wallqvist
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi, 

does any one have an example on how to call the optim.mask(with Optim Data Privacy LOOKUP) from LUA in Optim LUW?

Documentation is not quite clear, or perhaps i haven't found the right one :)

I want to send a variable as the source value and get it back as variable.
Then i will do some more concatenation before setting the column value for the target.

I want to use it direct from Optim classic by putting it in to a column map procedure.
(We don't have the designer installed) I have manage to execute LUA code this way by exporting the column map procedure, edit the script (Remove all capitals on reserved words like String etc) and then import it again.

best regards, 
Per

------------------------------
Per Wallqvist
------------------------------

#InfoSphereOptim
#Optim

Hi Ed and thanks for your help.

We are still struggling and will rase a PMR to get more clearity in how and if the lookup funktion works when calling using optmmask() funktion from lua and a CMP in Optim LUW

So i still look for more answers if someone got any input on this.

Cheers, 
Per

------------------------------
Per Wallqvist
------------------------------

Original Message:
Sent: 01-16-2019 07:08 AM
From: Ed Lipson
Subject: Example optim.mask() with LUA using lookup function Optim LUW

​I have a failed example from a few years ago for masking a Brazil NID. Is commented out towards the end.

That was the only LUA we wrote, for the two Brazil NIDs.

------------------------------
Ed Lipson
BNYMellon
Brooklyn NY
718 315 4763

Original Message:
Sent: 01-15-2019 02:48 PM
From: Per Wallqvist
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi, 

does any one have an example on how to call the optim.mask(with Optim Data Privacy LOOKUP) from LUA in Optim LUW?

Documentation is not quite clear, or perhaps i haven't found the right one :)

I want to send a variable as the source value and get it back as variable.
Then i will do some more concatenation before setting the column value for the target.

I want to use it direct from Optim classic by putting it in to a column map procedure.
(We don't have the designer installed) I have manage to execute LUA code this way by exporting the column map procedure, edit the script (Remove all capitals on reserved words like String etc) and then import it again.

best regards, 
Per

------------------------------
Per Wallqvist
------------------------------

#InfoSphereOptim
#Optim

I have attached some sample LUA scripts and let me know if you need any clarifications I should be able to help you.
Many of Optim customers making use similar use cases.

------------------------------
Tulasi Uppu
------------------------------

Original Message:
Sent: 02-07-2019 03:34 AM
From: Per Wallqvist
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi Ed and thanks for your help.

We are still struggling and will rase a PMR to get more clearity in how and if the lookup funktion works when calling using optmmask() funktion from lua and a CMP in Optim LUW

So i still look for more answers if someone got any input on this.

Cheers, 
Per

------------------------------
Per Wallqvist

Original Message:
Sent: 01-16-2019 07:08 AM
From: Ed Lipson
Subject: Example optim.mask() with LUA using lookup function Optim LUW

​I have a failed example from a few years ago for masking a Brazil NID. Is commented out towards the end.

That was the only LUA we wrote, for the two Brazil NIDs.

------------------------------
Ed Lipson
BNYMellon
Brooklyn NY
718 315 4763

Original Message:
Sent: 01-15-2019 02:48 PM
From: Per Wallqvist
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi, 

does any one have an example on how to call the optim.mask(with Optim Data Privacy LOOKUP) from LUA in Optim LUW?

Documentation is not quite clear, or perhaps i haven't found the right one :)

I want to send a variable as the source value and get it back as variable.
Then i will do some more concatenation before setting the column value for the target.

I want to use it direct from Optim classic by putting it in to a column map procedure.
(We don't have the designer installed) I have manage to execute LUA code this way by exporting the column map procedure, edit the script (Remove all capitals on reserved words like String etc) and then import it again.

best regards, 
Per

------------------------------
Per Wallqvist
------------------------------

#InfoSphereOptim
#Optim

Hello Per,

I would recommend to review the Lookup provider documentation on the below link. It has details on how to create the parameter string required for lookup function and use it inside optimmask() function
https://www.ibm.com/support/knowledgecenter/en/SSMLQ4_11.3.0/com.ibm.nex.designer.doc/oxy_ex-1/com.ibm.nex.mod.doc/topics/opmod-c--lookup_providers.html


------------------------------
Thanks,
Ankur Agrawal
------------------------------

Original Message:
Sent: 02-08-2019 02:44 AM
From: Tulasi Uppu
Subject: Example optim.mask() with LUA using lookup function Optim LUW

I have attached some sample LUA scripts and let me know if you need any clarifications I should be able to help you.
Many of Optim customers making use similar use cases.

------------------------------
Tulasi Uppu

Original Message:
Sent: 02-07-2019 03:34 AM
From: Per Wallqvist
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi Ed and thanks for your help.

We are still struggling and will rase a PMR to get more clearity in how and if the lookup funktion works when calling using optmmask() funktion from lua and a CMP in Optim LUW

So i still look for more answers if someone got any input on this.

Cheers, 
Per

------------------------------
Per Wallqvist

Original Message:
Sent: 01-16-2019 07:08 AM
From: Ed Lipson
Subject: Example optim.mask() with LUA using lookup function Optim LUW

​I have a failed example from a few years ago for masking a Brazil NID. Is commented out towards the end.

That was the only LUA we wrote, for the two Brazil NIDs.

------------------------------
Ed Lipson
BNYMellon
Brooklyn NY
718 315 4763

Original Message:
Sent: 01-15-2019 02:48 PM
From: Per Wallqvist
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi, 

does any one have an example on how to call the optim.mask(with Optim Data Privacy LOOKUP) from LUA in Optim LUW?

Documentation is not quite clear, or perhaps i haven't found the right one :)

I want to send a variable as the source value and get it back as variable.
Then i will do some more concatenation before setting the column value for the target.

I want to use it direct from Optim classic by putting it in to a column map procedure.
(We don't have the designer installed) I have manage to execute LUA code this way by exporting the column map procedure, edit the script (Remove all capitals on reserved words like String etc) and then import it again.

best regards, 
Per

------------------------------
Per Wallqvist
------------------------------

#InfoSphereOptim
#Optim

Has the OP or anyone else actually been able to perform a HASH_LOOKUP from a LUA script using Optim Classic?

I have not been able to get any of the samples given in this thread to work nor have I been able to get anything to work using the existing documentation.  


------------------------------
Tammy Forlenza
------------------------------

Original Message:
Sent: Tue January 15, 2019 02:48 PM
From: Per Wallqvist
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi, 

does any one have an example on how to call the optim.mask(with Optim Data Privacy LOOKUP) from LUA in Optim LUW?

Documentation is not quite clear, or perhaps i haven't found the right one :)

I want to send a variable as the source value and get it back as variable.
Then i will do some more concatenation before setting the column value for the target.

I want to use it direct from Optim classic by putting it in to a column map procedure.
(We don't have the designer installed) I have manage to execute LUA code this way by exporting the column map procedure, edit the script (Remove all capitals on reserved words like String etc) and then import it again.

best regards, 
Per

------------------------------
Per Wallqvist
------------------------------

#InfoSphereOptim
#Optim

Try the Below sample Code :

Line1 = 'pro=hash_lookup, hashfld="SEQ_KEY", '
Line2 = 'source="FIRST_NM", rep="FNAME_UPPER", '
Line3 = 'id=STDM_LOOKUP.NAME_MASK_LOOKUP, lib=ORACLE, conn=<DB_NAME>, '
Line4 = 'user=<LOOKUP_USERID>, pass="<LOOKUP_TBL_PWD>", '
Line5 = 'flddef1=(name=FIRST_NM, dt=wvarchar_sz), '
Line6 = 'flddef2=(name=FNAME_UPPER, dt=wvarchar_sz)'
mask_parms_hash = Line1..Line2..Line3..Line4..Line5..Line6
maskfxname1 = optim.mask(fxname1, mask_parms_hash)  fxname1 is the Source, where the data to be masked
optim.target.setcolumnvalue(maskfxname1)

We use Designer to update the PROC. But now sure , if it works directly with Classic flavor. But this is the way to use LOOKUP in LUA.

Thanks,
Joseph R

------------------------------
Joseph Jeba Kumar Ravindran
------------------------------

Original Message:
Sent: Thu April 25, 2019 03:27 PM
From: Tammy Forlenza
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Has the OP or anyone else actually been able to perform a HASH_LOOKUP from a LUA script using Optim Classic?

I have not been able to get any of the samples given in this thread to work nor have I been able to get anything to work using the existing documentation.  


------------------------------
Tammy Forlenza

Original Message:
Sent: Tue January 15, 2019 02:48 PM
From: Per Wallqvist
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi, 

does any one have an example on how to call the optim.mask(with Optim Data Privacy LOOKUP) from LUA in Optim LUW?

Documentation is not quite clear, or perhaps i haven't found the right one :)

I want to send a variable as the source value and get it back as variable.
Then i will do some more concatenation before setting the column value for the target.

I want to use it direct from Optim classic by putting it in to a column map procedure.
(We don't have the designer installed) I have manage to execute LUA code this way by exporting the column map procedure, edit the script (Remove all capitals on reserved words like String etc) and then import it again.

best regards, 
Per

------------------------------
Per Wallqvist
------------------------------

#InfoSphereOptim
#Optim

Joseph,

Thanks for the help.  It could possibly be a Classic issue. 
The problem is in the parameters as best I can tell. It seems there may be some truncation occurring.  I get the below error about FLDDEF missing when it is there.  However, if I shift the parameters around so that FLDDEF is in the front, then another parameter at the end of the string is reported missing.

User DLL or Proc requested termination while processing
XXXXXXX.YYYYYYY.OPTIM_CUSTOMERS
Column Map Procedure set on column CUSTNAME encountered an error at line 18
while processing row 1: optimmask: Parser_Service: ODPP Parser: IOQDP3060E: The
mandatory parameter FLDDEF was not found.



This is what the parameter string looks like.

stat_parm = ''PRO=HASH_LOOKUP,SRC=CUSTNAME,HASHFLD="SEQ_KEY",''
stat_parm = stat_parm .. ''REP="CNAME_FIRST_PROPER",''
stat_parm = stat_parm .. 'lib=DB2LUW,'
stat_parm = stat_parm .. 'conn=FEDSEVR,'
stat_parm = stat_parm .. 'user=<user_id>,'
stat_parm = stat_parm .. ''pass="xxxxxxxxxx",''
stat_parm = stat_parm .. ''FLDDEF1=(NAME=CUSTNAME,DT=wchar),''
stat_parm = stat_parm .. ''FLDDEF2=(NAME=CNAME_FIRST_PROPER,DT=wchar),''
stat_parm = stat_parm .. ''id=<schema>.NAME_MASK_LOOKUP''

I was hoping to find a solution here before submitting a PMR. 

Thanks,

Tammy

------------------------------
Tammy Forlenza
------------------------------

Original Message:
Sent: Fri April 26, 2019 03:08 AM
From: Joseph Jeba Kumar Ravindran
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Try the Below sample Code :

Line1 = 'pro=hash_lookup, hashfld="SEQ_KEY", '
Line2 = 'source="FIRST_NM", rep="FNAME_UPPER", '
Line3 = 'id=STDM_LOOKUP.NAME_MASK_LOOKUP, lib=ORACLE, conn=<DB_NAME>, '
Line4 = 'user=<LOOKUP_USERID>, pass="<LOOKUP_TBL_PWD>", '
Line5 = 'flddef1=(name=FIRST_NM, dt=wvarchar_sz), '
Line6 = 'flddef2=(name=FNAME_UPPER, dt=wvarchar_sz)'
mask_parms_hash = Line1..Line2..Line3..Line4..Line5..Line6
maskfxname1 = optim.mask(fxname1, mask_parms_hash)  fxname1 is the Source, where the data to be masked
optim.target.setcolumnvalue(maskfxname1)

We use Designer to update the PROC. But now sure , if it works directly with Classic flavor. But this is the way to use LOOKUP in LUA.

Thanks,
Joseph R

------------------------------
Joseph Jeba Kumar Ravindran

Original Message:
Sent: Thu April 25, 2019 03:27 PM
From: Tammy Forlenza
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Has the OP or anyone else actually been able to perform a HASH_LOOKUP from a LUA script using Optim Classic?

I have not been able to get any of the samples given in this thread to work nor have I been able to get anything to work using the existing documentation.  


------------------------------
Tammy Forlenza

Original Message:
Sent: Tue January 15, 2019 02:48 PM
From: Per Wallqvist
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi, 

does any one have an example on how to call the optim.mask(with Optim Data Privacy LOOKUP) from LUA in Optim LUW?

Documentation is not quite clear, or perhaps i haven't found the right one :)

I want to send a variable as the source value and get it back as variable.
Then i will do some more concatenation before setting the column value for the target.

I want to use it direct from Optim classic by putting it in to a column map procedure.
(We don't have the designer installed) I have manage to execute LUA code this way by exporting the column map procedure, edit the script (Remove all capitals on reserved words like String etc) and then import it again.

best regards, 
Per

------------------------------
Per Wallqvist
------------------------------

#InfoSphereOptim
#Optim

Hi Tammy,

Try the attached one.

Regards,
Fritz

------------------------------
FRIEDRICH PFNEISL
Optim SME
Austria
------------------------------

Original Message:
Sent: Thu April 25, 2019 03:27 PM
From: Tammy Forlenza
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Has the OP or anyone else actually been able to perform a HASH_LOOKUP from a LUA script using Optim Classic?

I have not been able to get any of the samples given in this thread to work nor have I been able to get anything to work using the existing documentation.  


------------------------------
Tammy Forlenza

Original Message:
Sent: Tue January 15, 2019 02:48 PM
From: Per Wallqvist
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi, 

does any one have an example on how to call the optim.mask(with Optim Data Privacy LOOKUP) from LUA in Optim LUW?

Documentation is not quite clear, or perhaps i haven't found the right one :)

I want to send a variable as the source value and get it back as variable.
Then i will do some more concatenation before setting the column value for the target.

I want to use it direct from Optim classic by putting it in to a column map procedure.
(We don't have the designer installed) I have manage to execute LUA code this way by exporting the column map procedure, edit the script (Remove all capitals on reserved words like String etc) and then import it again.

best regards, 
Per

------------------------------
Per Wallqvist
------------------------------

#InfoSphereOptim
#Optim

Hi Fritz, 

Okay, after a bit of fiddling I was able to get this to work.  The Len parameter for the flddef made all the difference.

Thanks for your help.

Tammy

------------------------------
Tammy Forlenza
------------------------------

Original Message:
Sent: Fri April 26, 2019 10:32 AM
From: FRIEDRICH PFNEISL
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi Tammy,

Try the attached one.

Regards,
Fritz

------------------------------
FRIEDRICH PFNEISL
Optim SME
Austria

Original Message:
Sent: Thu April 25, 2019 03:27 PM
From: Tammy Forlenza
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Has the OP or anyone else actually been able to perform a HASH_LOOKUP from a LUA script using Optim Classic?

I have not been able to get any of the samples given in this thread to work nor have I been able to get anything to work using the existing documentation.  


------------------------------
Tammy Forlenza

Original Message:
Sent: Tue January 15, 2019 02:48 PM
From: Per Wallqvist
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi, 

does any one have an example on how to call the optim.mask(with Optim Data Privacy LOOKUP) from LUA in Optim LUW?

Documentation is not quite clear, or perhaps i haven't found the right one :)

I want to send a variable as the source value and get it back as variable.
Then i will do some more concatenation before setting the column value for the target.

I want to use it direct from Optim classic by putting it in to a column map procedure.
(We don't have the designer installed) I have manage to execute LUA code this way by exporting the column map procedure, edit the script (Remove all capitals on reserved words like String etc) and then import it again.

best regards, 
Per

------------------------------
Per Wallqvist
------------------------------
​​
#InfoSphereOptim
#Optim

Hi Fritz and Tammy, 
can you post the Lua procedure correctly formatted? because I can't run hash_lookup on a db oracle table.

Then I have some doubts:
-user: is the user access to the db oracle or ad optim?
-conn: is the name of the dbalias or the connection string that I put in tnsnames.ora?
-lib: in my case should I insert 'ORACLE'?

Thanks for your help.

Giuseppe

------------------------------
Giuseppe Cotugno
------------------------------

Original Message:
Sent: Mon April 29, 2019 11:26 AM
From: Tammy Forlenza
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi Fritz, 

Okay, after a bit of fiddling I was able to get this to work.  The Len parameter for the flddef made all the difference.

Thanks for your help.

Tammy

------------------------------
Tammy Forlenza

Original Message:
Sent: Fri April 26, 2019 10:32 AM
From: FRIEDRICH PFNEISL
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi Tammy,

Try the attached one.

Regards,
Fritz

------------------------------
FRIEDRICH PFNEISL
Optim SME
Austria

Original Message:
Sent: Thu April 25, 2019 03:27 PM
From: Tammy Forlenza
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Has the OP or anyone else actually been able to perform a HASH_LOOKUP from a LUA script using Optim Classic?

I have not been able to get any of the samples given in this thread to work nor have I been able to get anything to work using the existing documentation.  


------------------------------
Tammy Forlenza

Original Message:
Sent: Tue January 15, 2019 02:48 PM
From: Per Wallqvist
Subject: Example optim.mask() with LUA using lookup function Optim LUW

Hi, 

does any one have an example on how to call the optim.mask(with Optim Data Privacy LOOKUP) from LUA in Optim LUW?

Documentation is not quite clear, or perhaps i haven't found the right one :)

I want to send a variable as the source value and get it back as variable.
Then i will do some more concatenation before setting the column value for the target.

I want to use it direct from Optim classic by putting it in to a column map procedure.
(We don't have the designer installed) I have manage to execute LUA code this way by exporting the column map procedure, edit the script (Remove all capitals on reserved words like String etc) and then import it again.

best regards, 
Per

------------------------------
Per Wallqvist
------------------------------
​​
#InfoSphereOptim
#Optim