Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 22 Feb 2006 @ 21:58:58 GMT


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


Subj:   ODBC Queries repeated
 
From:   JANIK, ROBERT B

We have an issue with ODBC driven software and Teradata. Users accessing Teradata via the Sql Assistant "import" feature or MS Access can easily create "repeated" queries.

For example; if an MS Access user does a Select using an MS Access table and a linked Teradata table, one Select statement is generated for each row in the MS Access table. In other words if the MS Access table has ten thousand rows, ten thousand Select statements are submitted to the Teradata system

The same occurs with the Sql Assistant Import feature. If a user Inserts ten thousand records from a sequential, PC based file, ten thousand Insert statements are submitted into the Teradata system.

It is my understanding that these queries are "repeated" due to the nature of the Teradata ODBC driver. My question is; has anyone found a way to either a go-around or correct this situation?


Thanks,

Bob J.



     
  <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