Profile

Hi Rajesh, The format that Optim uses for Date colum is driven by the date format in your source database. Either you can modify the date format in your source DB or you can try following manipulation via Optim to reformat the date/timestamp column. I have not implemented this concept before, so ...

Hi Sampath, you need to open the lua editor in hex mode and sample code will look like this. Refer to the bold characters -------------- sÝ1¨ = 'test' AAFB4747A8AA7 2D1D0E0D3523D For Carrot symbol (^) please use X'5F' it will display as ¬ ------------------------------ Ankur Agrawal ---- ...

Hi Sampath, Some IBM 3270 emulators do not recognize square bracket characters as there is not a consistent definition of what codes represent them. Hosts may define the square bracket characters as X'BA' and X'BB' , or as X'AD' and X'BD'. We use hex mode on the Lua editor to modify the square bracket ...

Hi Sampath, If you are running this code natively on z/OS, Optim Data Privacy should use the embedded SQL interface. You don't need the following line in your code. tparm = tparm .. 'CONN="DBCONN",USER=USER,PASS=PASSWORD,' Please refer the link for details - https://www.ibm.com/support/pages/u ...

Hi Hari, Yes CONN parameter would be same as the connection string that you would have used to create a connection to DB server i.e. ODBC DSN. ------------------------------ Ankur Agrawal ------------------------------