Archives of the TeradataForum
Message Posted: Tue, 17 Nov 2015 @ 19:05:31 GMT
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!
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|