Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 16:59:38 GMT


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


Subj:   Re: Fast Path Insert
 
From:   Fachtna ODonovan

You can use a Multi Statement Request (MSR)

In BTEQ you can submit the following

INSERT INTO TABLE_EMPTY SELECT * FROM TABLE
;INSERT INTO TABLE_EMPTY SELECT * FROM TABLE1;

This will submit the two statements in parallel into TABLE_EMPTY with no TJ. The position of semicolon on the second line is important as otherwise it request will be treated as two insert statements.

You can submit the same request in Queryman by hitting F9 to execute the request in parallel, as a MSR. (The position of the semicolon isn't important for Queryman.)


Hope this helps,

Fachtna



     
  <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