​Hi All,
I am trying to write LUA script for FullName field using Hash_Lookup.
we have a lookup table in one of DB Alias within our Optim Directory.
I wanted to avoid passing USER ID and Password parameters in LUA scripts.
Please advise the options.
When I try the script without user ID and Pass getting below error.

Error : Failed to create OCI environment

------------------------------
Harshavardhan Peddireddy
------------------------------

#InfoSphereOptim
#Optim

Hello Harshavardhan,

If you do wish to expose userid and password in LUA scripts, you can try this :-

optim.dbalias.getuser("<DBAiasName>")
optim.dbalias.getpassword("<DBAliasName>")

Thanks,
Suraj Shingri

------------------------------
Suraj Shingri
------------------------------

* Sorry for the typo, if you do not** wish to....

Thanks,
Suraj Shingri

------------------------------
Suraj Shingri
------------------------------

Original Message:
Sent: Wed April 08, 2020 02:33 AM
From: Suraj Shingri
Subject: HASH_LOOKUP

Hello Harshavardhan,

If you do wish to expose userid and password in LUA scripts, you can try this :-

optim.dbalias.getuser("<DBAiasName>")
optim.dbalias.getpassword("<DBAliasName>")

Thanks,
Suraj Shingri

------------------------------
Suraj Shingri
------------------------------

Thank you so much Suraj,

Yes, your suggestion worked.

Adding some additional notes from trails. Just in case it helps others.

What's new in 11.3.0 Fix Pack 5
Remove Clear Text Passwords for ODPP lookup functions in Lua.

Lua Column Map procedures no longer need to code the password as clear text in the Lua Column Map procedure source text. The following new Optim functions are provided to extract the values from a named DBAlias defined in the Optim Environment:

optim.dbalias.getconnect(dbalias_name) – Retrieve the connect string associated with the named DBAlias.

optim.dbalias.getuser(dbalias_name) – Retrieve the RDBMS User name associated with the named DBAlias.

optim.dbalias.getpassword(dbalias_name) – Retrieve the password for the User name associated with the named DBAlias.

The values retrieved from the invocation of these new functions are then used during the construction of the ODPP Lookup command. Normally the command string is constructed by concatenating a series of String Literals and values to form the complete command.

​

------------------------------
Harshavardhan Peddireddy
------------------------------

Original Message:
Sent: Wed April 08, 2020 02:33 AM
From: Suraj Shingri
Subject: HASH_LOOKUP

Hello Harshavardhan,

If you do wish to expose userid and password in LUA scripts, you can try this :-

optim.dbalias.getuser("<DBAiasName>")
optim.dbalias.getpassword("<DBAliasName>")

Thanks,
Suraj Shingri

------------------------------
Suraj Shingri
------------------------------