Hello,
I’ve created an Hotspot button in a form to import data from DB2 and for do that I uses LSX.
the database is strored on an AS400 server and the table DB2 also.
but when I uses the button, I’ve this Error Message : “error creating product object” on this line :
Dim LC_Conn As New LCConnection("db2")
I haven’t installed DB2 client on my computer but I know that DB2 is installed on the AS400.
Anyone can help me ?
Thanks
Subject: Problem when I use LSX for the access to DB2
You should move your LSX code to a server agent (scheduled Never). Call that agent from your hotspot by passing the current document’s Note ID.
Subject: RE: Problem when I use LSX for the access to DB2
Using RunOnServer, he means.
Subject: Problem when I use LSX for the access to DB2
Up
Subject: RE: Problem when I use LSX for the access to DB2
Ok, I will try this option.
Thanks for your help
Subject: Problem when I use LSX for the access to DB2
you are very Great! it’s run …but I would like transfert the data imported into my current doc, but the agent don’t recognize my current doc and there is a new and not yet saved.
you have an idea ?
Subject: RE: Problem when I use LSX for the access to DB2
You can create a Temporary document in the Server Agent that accesses iSeries DB2. When the agent is done, the control will come back to your Form Lotus Script.
In your Form Lotus script, after the server agent is done, access the Temporary document to populate current document.
HTH