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?