Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 13 Jun 2003 @ 20:19:11 GMT


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


Subj:   Re: Perl and DBD::Teradata 1.13
 
From:   Adriano Ferreira

Thanks, Geoffrey.

The loop does not finish prematurely anymore. Now I opened two connections and used one to SELECT and another to UPDATE. My idea was to use the SELECT to drive a loop and then an UPDATE to make certain corrections over the same data. And when I tried to do it, the script blocks. Probably it has to do with the fact that the same table is being accessed and the transaction type locks the table. Or maybe I should use a SELECT FOR UPDATE. I thought it would be a lot easier (as I already did with DBD::Oracle, DBD::ODBC, and DBD::Interbase).

Many thanks. And sorry for not reading more carefully the documentation. The issue reported above is probably answered by the documentation as well.

Best regards,

Adriano.

Adriano Rodrigues Ferreira
Analista de Sistemas
Metodologia e Controle de Processos/Tecnologia da Informação
Peixoto Ind. Com. Trans. e Serv. Ltda



     
  <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