  |  
  |  
 
Archives of the TeradataForum 
 
 
Message Posted: Thu, 23 Feb 2006 @ 17:44:28 GMT 
 
  
 
 
 
 
  
|  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 
 
 
 
 
   
 
 |   |