where do i declare the user temporary tablespace?

cuddles

hi,
i hve some global temporary tables and it seems i have to declare temporary user tablespace as well.

whats the syntax for this and where do i declare it say in a stored procedure? before the declaration of the global temporary table?

im using db2 version 8..im not sure if i have to declare a tablespace with the Create Table Space wizard.

Jun 21 '07 #1