MVSFORUMS.com

[Jai]

Hi Friends,

Please let me know is it necessary to drop the Global Temporary Table(GTT). Logically it should delete the GTT as soon as SP call is over and also we have given on commit delete rows. So it should drop at that time when we call from Java.
But here in our we have to make it a explicity by the statement drop table session.<gttname>.
It is working fine here. But for moving it to Production, we need to move it to Changeman and then to Production. But Changeman is not accepting the DROP Procedure while Staging. So Please suggest me the Possible solution for that.

Thanks in advance.
_________________
Have a Great Day.
Thanks & Regards,
Jai

[kolusu]

Jai,

After you execute a DECLARE GLOBAL TEMPORARY TABLE statement, the definition of the declared temporary table exists as long as the application process runs.. After your application is completed the temporary table is dropped automatically. If you really need to delete the definition before the application process completes, you can do that with the DROP TABLE statement.

Hope this helps...

cheers

kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu