How can I query 2 different tables and get the result in 2 different result sets using 1 connector

Submitted by ffernandezc on Wed, 09/30/2015 - 17:05
1
0
-1

Hi,

I want to know if it is possible to use only one connector in order to execute 2 or more different select querys and store the returned values in differents resultsets.

And also if it is possible how to do it

Thanks.

SQL
Connector
Database
multiple querys
resultsets
1 answer

Submitted by yannick.lombardi on Wed, 09/30/2015 - 17:29
1
+1
-1

Hi.

My answer is yes and no.

No because you can't do this if you use the default sql connector. They accept only 1 query and return 1 resulset.

Yes because you can create your own connector that will execute 2 or more query and return 2 or more resultset.

If you have two distincts queries, I recommand to create two task that will both execute one query. It is more readable.

Notifications