I have wrote an agent that uses the LSX extention of lotus script to access data on DB2, this agent works fine when the DB2 database is on the same AS/400 that the domino server but my agent do not work properly when a remote DB2 on an another AS/400 is used. the error message in the domino console of the server is
"Error N 12325 error module SQL QSQCLIPKGN not found in QGPL connector 'DB2' (-805)".
The connection between the 2 as/400 is made with TCPIP and the command WRKRDBDIRE is used to declare the remote database on the other AS/400. Just before the print of the error message, the ports 446 (*DRDA) starts exhanging some Data betwenn the 2 AS/400 systems. (the connexion seems to work well) Is there any other special statement to add to my script ?
The Domino server version is 4.6.3a The OS/400 version of the 2 AS/400 is V4R3M0
I have to create an SQL Module to make the connexion works well, but my question is how to create this module ?
with Lotus Domino/Notes ?
Thanks for your help
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.