By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,557 Members | 1,068 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,557 IT Pros & Developers. It's quick & easy.

Temporary table in DB2

P: 48
Hi,

I have used a temporary table in DB2 SQL. Below is the definition..

DECLARE GLOBAL TEMPORARY TABLE SESSION.TEMP1
( IBPSUB DECIMAL(12) ,
IBPQTN DECIMAL(12) ,
CLASS CHAR(4) ,
ASSETS DECIMAL(12) ) ON COMMIT PRESERVE ROWS ;


It was working fine when the DB2 version was V7.2 but now the DB2 has been migrated from V7 to V8. In DB2 V8 I am getting following error message when I try to create temporary table:

[IBM][CLI Driver][DB2] SQL0904N Unsuccessful execution caused by an unavailable resource. Reason code: "00E7009A", type of resource: "200", and resource name: "TABLESPACE IN TSTTMP". SQLSTATE=57011


I am new to DB2 SQL , so please suggest me what to do.

Thanks ,
Santosh
Jul 23 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.