Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   Executing multiple SQLs in parallel through JDBC
From:   Pudhota, Kiran K


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.


Best regards,


  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020