467,113 Members | 1,351 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,113 developers. It's quick & easy.

Temporary table in DB2

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
  • viewed: 2609
Share:

Post your reply

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

Similar topics

reply views Thread by Didier ROS | last post: by
11 posts views Thread by randi_clausen@ins.state.il.us | last post: by
reply views Thread by nedbollard@netscape.net | last post: by
5 posts views Thread by Adam W. Saxton | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.