Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2004
    Posts
    39

    Unanswered: [DB2 V7] temporary table

    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.
    Last edited by geoffrey; 06-29-04 at 12:18.
    geoffrey
    - Four J's Development Tools -

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Look in the manual for "DECLARE GLOBAL TEMPORARY TABLE".

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •