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
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