Archives of the TeradataForum

Message Posted: Fri, 21 Nov 2003 @ 14:33:42 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Executing multiple SQLs in parallel through JDBC

From:		Pudhota, Kiran K

Hi,

We have a requirement to execute multiple SQLs, in parallel, using JDBC. We have about 7 SQLs, and in order to reduce the response time, would like to execute them in a parallel fashion. Is there any way to do this?

The 7 SQLs are simple select statements, each returning 1 to 30 records. Currently this takes over 20 seconds.

We are using Teradata Driver for JDBC, release 02.02.00

We were looking at 2 options:

[1] Statement.execute, getMoreResults, getResultSet - How would one code multiple SQL statements as a single String. (separate using ; ?)

[2] Write a stored procedure to return 7 out parameters as cursors - Would this help in reducing the overall time to a great extent? Would appreciate if you could point us to some sample code that shows how to work with cursors in Teradata stored procedures.

Thanks.

Best regards,

-Kiran.