Ranga wrote:
We are developing on Unix UDB DB2 and deploying it on z/OS DB2. Could
you please let me know if create global temporary table feature is not
available in Unix UDB DB2. We have to use Create global temporary
table in our project and i know that it is supported in z/OS.
Thanks,
Ranga
Good answer I can work with that as a requirement :-)
Knut is correct. What customer do is to encapsulate teh DECLARED global
temp DDL inside of a stored procedure.
When you move to DB2 z/Series all you need to do is remove the CALL.
(or you can do the call and tolerate the syntax error from DB2 z)
Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab