Hello everyone:
I was told that IBM had recommended to move from ODBC calls to LSX calls. I had been searching for information on this issue but I have not been able to find anything that directly explains this issue. Is this true? What are the reasons for it? Are there any best practices to follow when doing the change?If anyone had information on this or can point me in the correct direction it will be appreciated.
Thanks,
Mynor de Paz
Subject: Deprecated …
I had a few issues with ODBC when I upgraded my iSeries from Domino 8.5.3 to 9.0.1 a few years ago, and had a number of IBM Support people tell me that the use of LSXODBC was being deprecated. It wasn’t being removed, but wasn’t being enhanced or updated and may end up not being able to get support if something goes awry, the use of LSXLC was recommended.
I updated most (not all) of my LSXODBC agents to instead use LSXLC - I found these to be helpful:
http://www-01.ibm.com/support/docview.wss?rs=899&uid=swg21233597 http://www-01.ibm.com/support/docview.wss?rs=899&uid=swg21233597
IBM Developer https://www.ibm.com/developerworks/lotus/library/DB2-procedures/
I did find that the use of LSXLC stored procedures did seem to be faster in some cases, as well as making remote calls easier to program.
Subject: Thanks for the response
Hi Mark:
Thanks for the response and the links. I will take a look and start working on how to change the code so that we start using LSXLC. If you have any other comments or information I will appreciate it. I will be modifying web applications that communicate with SQL databases.
Mynor de Paz