Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 23 Feb 2006 @ 17:44:28 GMT


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


Subj:   Re: ODBC Queries repeated
 
From:   Dieter Noeth

Mike Dempsey wrote:

  As was stated earlier, unless you use the load utilities, the only mechanism for inserting data is the standard Insert statement.  


  You can however use multi-statement requests to send multiple Insert statements as 'packages'. (This is how TPump works)  


A much faster way would be using ODBC parameter arrays, similar to BTEQ's PACK.

Supported since V2R6 and it was a performance boost for BTEQ IMPORTs...

Is there already an ER to add that to QueryMan?


Dieter



     
  <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