Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 13 May 2004 @ 18:36:11 GMT


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


Subj:   Re: Feedback on Global Temporary Tables
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, May 13, 2004 14:29 -->

Thanks to all that offered their expertise on GTT.

I discovered that because of the limitations of macros, one could not effectively collect statistics on GTT from within a macro. However, the GTT helped simplify the creation of tables (and reducing the size of the macro) within a macro. However, when in Queryman, the instances don't go away.

Perhaps someone can comment on the interesting issue that I found with these tables within a macro and within Queryman. Running the query the first time creates instances of the Global tables (not a problem). At the end of the macro, I delete all from all global tables. Yet if I run the macro again without disconnecting, it thinks that the rows are still in the table (and therefore that there are Uniqueness violations). This query which ran in seconds the first time, if run again runs for quite a long time before UV errors come up. I thought that since I deleted the rows inside the macro that this would clear the rows out. This does not seem to be the case. If I disconnect and reconnect, this eliminates the problem (of course). But I thought this funny.


Thanks again!



     
  <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