We help IT Professionals succeed at work.

lotusscript and ODBC connection

varvoura asked
Last Modified: 2013-12-18
Hi all,
Lotusscript agent and ODBC query

I have a lotusscript ODBC agent in which I am making a connection to a backend datasource and then I am getting the first result set. Based on that I am using another query(query2) based on a key and on the result returned from the first query to perform the operation that I need.
That's all working great.

Now I was just asked to do some additional validation on some products which happen to reside on a different datasource than my previous one. Thinking about this, I wanted to attempt to do this all within the one agent although the two datasources are different.

My question is:

Can I do this? use the first datasource to get the first result set, then invoke query two to filter through and perform what I need based on a subset of the returned result from query one(sitll same datasource) but before I close that first datasource and still within the loop can I open a second connection to a different datasource, and again use the result set of query2 connection 2 as the basis or working with the returned result set from the second connection to the second datasource.

I hope that I did confuse you guys basically I want to do it all in the one go.
Is it possible?

Watch Question

This one is on us!
(Get your first solution completely free - no credit card required)
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.