Problem when I use LSX for the access to DB2

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