Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 Nov 2003 @ 18:30:35 GMT


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


Subj:   Re: Executing multiple SQLs in parallel through JDBC
 
From:   Victor Sokovin

Kiran,

On Fri, 21 Nov 2003 09:33:42 -0500, Pudhota, Kiran K wrote:

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


DR61092 seems to suggest that multi-statements requests (MSR) do not work with the JDBC driver 02.02.


  [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.  


Have you considered a macro with 7 queries? It will run as an MSR and will perhaps be the easiest option. It is also likely to be faster than an SP when executed multiple times. You can find some run time statistics in this month's thread "Stored Procedures or Macros".


Regards,

Victor



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