LSX error when accessing remote DB2/400 -- DOMINO400

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

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

Damien Mounier

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.