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?


  <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: 28 Jun 2020