lotusscript and ODBC connection

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?

Thanks
Varvoura