All Forums Tools
gstoel 2 posts Joined 12/12
03 Oct 2014
Multiple queries in one connectiong through Teradata studio / Eclipse plugin

Hi,
In SQL Assistant it is possible to run multiple queries in parallel (after setting some of the settings correct). I prefer to use Teradata Studio, the eclipse plugin, but couldn't find a setting to do so. Is it possible anyway to run multiple queries in parallel? I now have to wait for my queries to finish before I can continue.
Regards,
 
Geoffrey

Raja_KT 1246 posts Joined 07/09
03 Oct 2014

For now I can think of  MSR or macros, where you design statements that do not have /share dependencies are executed  in parallel

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Chuckbert 78 posts Joined 07/09
06 Oct 2014

The latest version of Studio you can download is able to run statements against the same database system in parallel. You will need to run the statements from different SQL Editors. If you run the multiple statements, even if you run them separately, from the same SQL Editor, the statements will be run sequentially. Each SQL Editor will use its own connection to the database system and a connection can run one statement at a time.

You must sign in to leave a comment.