Unanswered: [DB2 V7] temporary table
Does anybody knows the SQL syntaxe to create a temporary table with DB2 v7 ( on aix 4.3.3) ?
I've tried different statement and no one seems to work :
a. db2 CREATE TEMPORARY TABLE TEMP_EMP1 ( no INTEGER)
--> gives me the following error :
DB21034E The command was processed as an SQL statement because it was not a
valid Command Line Processor command. During SQL processing it returned:
SQL0104N An unexpected token "TEMPORARY" was found following "CREATE ".
Expected tokens may include: "<space>". SQLSTATE=42601
b. db2 CREATE <directoryA> TEMPORARY TABLE TEMP_EMP1 ( no INTEGER)
(where directoryA is a empty dir located in the current dir)
--> creates a dir TEMPORARY in the current dir
I've tried with GLOBAL also but without success.
Thx in advance for your help.
Last edited by geoffrey; 06-29-04 at 11:18.
- Four J's Development Tools -