Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 17 Nov 2015 @ 19:05:31 GMT


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


Subj:   Question on Global Temp tables
 
From:   Bakthavachalam, Roopalini

Hi Forum

I have an application which uses GTTs. When I select some conditions on the front end, a store procedure is called on Teradata (backend) which uses GTTs to do some computation and gives the count as output. Now I delete the TEMP tables in the beginning of the procedure, so that every time it inserts new data according to the conditions chosen on the front end to give the output. I am facing a weird issue here. When I get a count for a certain scenario and immediately go back change some condition, I should get new count according to the changed condition, however I get the same count as I got the first time. After a few minutes, when I try to do the same, I get the correct count.

I suspect the GTT is not getting refreshed and it is giving the old count as output. Could anyone let me know, what?s going on? I am using GTTs with ON COMMIT PRESERVE ROWS.


Appreciate your responses!

Roopalini



     
  <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: 15 Jun 2023