List of Contributions

FRIEDRICH PFNEISL

Contact Details

My Content

1 to 18 of 18 total

RE: Long execution time of lookup function with error messages "Access Violation" in trace file

Posted By FRIEDRICH PFNEISL Thu March 04, 2021 02:51 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi Valentin, Is an index defined on both columns? Regards,Fritz

RE: Long execution time of lookup function with error messages "Access Violation" in trace file

Posted By FRIEDRICH PFNEISL Thu March 04, 2021 02:13 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi Valentin, What type of column is DICT1_CD? Is it similar like SEQ in the lookup-table? Regards,Fritz Friedrich Pfneisl Client Technical Specialist Data and AI-Information Architecture Phone: +43 664 6186302 E-mail: pfneisl@at.ibm.com

RE: working LUA on linux enviroment

Posted By FRIEDRICH PFNEISL Tue December 01, 2020 08:27 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi Valentin, Unfortunately your screen-shots don't work. However if the procedure works on your local server and does not work on the Linux server there "must" be a difference between those two and the error-message clearly points to a conversion-error of code-pages. I suggest you open a support-case. ...

RE: working LUA on linux enviroment

Posted By FRIEDRICH PFNEISL Tue December 01, 2020 02:57 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi Valentin, It seems that you have a character-conversion problem here because you run client and server with different codepages. Every locale (or its translation) that the server is required to handle must reside on the server machine. In other words, the server must have access to the locale ...

RE: restore one table

Posted By FRIEDRICH PFNEISL Tue December 01, 2020 02:52 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi Gunes, you should delete/blank out all the tables but the one you want to restore in the Insert-request. Regards, Fritz ------------------------------ FRIEDRICH PFNEISL Optim SME Austria ------------------------------

RE: Reading Mainframe Archives from Optim LUW

Posted By FRIEDRICH PFNEISL Mon October 19, 2020 08:48 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi, Sorry, but I thought my message was clear. As VSAM is not supported you can not restore it. Regards,Fritz

RE: Reading Mainframe Archives from Optim LUW

Posted By FRIEDRICH PFNEISL Mon October 19, 2020 08:06 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi, Never tried this as VSAM itself is not supported in distributed environment. But theoretically you should have access to the data and maybe you can import it into a newly created table? Regards,Fritz

RE: Reading Mainframe Archives from Optim LUW

Posted By FRIEDRICH PFNEISL Fri October 16, 2020 04:57 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi, 1. yes 2. data conversion should happen automatically Regards, Fritz ------------------------------ FRIEDRICH PFNEISL Optim SME Austria ------------------------------

RE: Reading Mainframe Archives from Optim LUW

Posted By FRIEDRICH PFNEISL Fri October 16, 2020 04:33 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi, You can copy the files from the mainframe and then you have to register them in the distributed environment (under "Utilities"). You can then treat them like "standard" distributed archive files (via Browser or ODM). Regards, Fritz ------------------------------ FRIEDRICH PFNEISL ...

RE: where to find 'z/OS Optim Connect Server Installation Guide'

Posted By FRIEDRICH PFNEISL Thu July 09, 2020 02:11 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi, It's located in the installation directory. For your convenience I'll attach it here. Regards, Fritz ------------------------------ FRIEDRICH PFNEISL Optim SME Austria ------------------------------

RE: where to find 'z/OS Optim Connect Server Installation Guide'

Posted By FRIEDRICH PFNEISL Thu July 09, 2020 02:10 AM
Found In Library: InfoSphere Optim
#InfoSphereOptim #Optim

RE: DataSource/Collection

Posted By FRIEDRICH PFNEISL Wed February 19, 2020 02:55 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi, Each collection represent one datasource, i.e. if you want to have 1 datasource only you should archive in 1 collection only. Regards, Fritz ------------------------------ FRIEDRICH PFNEISL Optim SME Austria ------------------------------

RE: Example optim.mask() with LUA using lookup function Optim LUW

Posted By FRIEDRICH PFNEISL Fri April 26, 2019 10:33 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi Tammy, Try the attached one. Regards, Fritz ------------------------------ FRIEDRICH PFNEISL Optim SME Austria ------------------------------

RE: Example optim.mask() with LUA using lookup function Optim LUW

Posted By FRIEDRICH PFNEISL Fri April 26, 2019 10:32 AM
Found In Library: InfoSphere Optim
#InfoSphereOptim #Optim

RE: Seeking help setting up Oracle DB Alias

Posted By FRIEDRICH PFNEISL Fri March 08, 2019 03:07 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi, Agree with Jimmy. Instant Client is not sufficient, you need full Oracle client. Regards, Fritz ------------------------------ FRIEDRICH PFNEISL Optim SME Austria ------------------------------

LUA and empty strings

Posted By FRIEDRICH PFNEISL Mon February 04, 2019 02:38 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi, Does anyone have experience with LUA and empty strings? How to check if a string is empty? "string.len" returns 25 for an empty varchar(25) column... Thanks, Fritz ------------------------------ FRIEDRICH PFNEISL Optim SME Austria ------------------------------ #InfoSphereOptim ...

RE: Extract/Insert Processing in Batch via PGM=FOPMAIN

Posted By FRIEDRICH PFNEISL Tue December 11, 2018 02:30 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi Michael, And you checked this requirement: ********************************** N O T E S ********************************** * You must have authority to update the Skeleton Library * * to complete this function successfully. * **************************************************************** ...

RE: Extract/Insert Processing in Batch via PGM=FOPMAIN

Posted By FRIEDRICH PFNEISL Thu December 06, 2018 04:08 AM
Found In Egroup: InfoSphere Optim \ view thread
Hi Michael, Did you try the customization as described here: https://www.ibm.com/support/knowledgecenter/SSC623_11.3.0/com.ibm.nex.optimz.customizing.doc/Chapter4/opzinstall-r-Customize_the_Batch_Environment.html Regards, Fritz ------------------------------ FRIEDRICH PFNEISL Optim SME ...