Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 24 Jan 2002 @ 16:18:11 GMT


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


Subj:   Execute Parallel
 
From:   Claybourne Barrineau

We use a third party multi-dimensional reporting tool on top of our Teradata Relational database. Unfortunately, this tool can only process (pass to Teradata and wait for a reponse) one SQL statement at a time. Therefore, if a user generates a report which creates 15 SQL statements, the user must wait as long as it takes to execute these 15 statements sequentially.

I am interested in the idea of sending multiple SQL statements to Teradata via the front-end tool (assuming we can somehow disguise these multiple SQL statements to look like a single SQL statement to the front-end tool.)If we could do this, is it possible to execute these multiple SQL statements in parallel via a direct ODBC connection between the front-end tool and Teradata? I know that I can currently do this using the 'Execute Parallel' option in Queryman and using the ';' trick in BTEQ; however, I don't know what the syntax would need to look like via a direct ODBC connection.


Thanks,

Claybourne Barrineau



     
  <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: 27 Dec 2016