 |
 |
Archives of the TeradataForum
Message Posted: Tue, 17 Nov 2015 @ 19:05:31 GMT
| 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
| |
