Hello,

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.

Look in the manual for "DECLARE GLOBAL TEMPORARY TABLE".

Andy