Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    33

    Unhappy Unanswered: What's wrong with thi temporary table?

    Hi, I'm wondering why this temporary table doesn't appear in my schema when I ceate it. More over, it doesn't appear, but when I try to create it again, I had a message that tell me it already exists!!!

    The SQL syntax is:

    ------------------------------------------------------------
    --
    -- Create table PUBLIC_ID_FILTER
    --
    --
    CREATE GLOBAL TEMPORARY TABLE
    PUBLIC_ID_FILTER
    (
    FILTER_NUMBER NUMERIC (12,0) NOT NULL,
    PUBLIC_ID VARCHAR(1024) NOT NULL
    )
    ;

    Please, help me.

  2. #2
    Join Date
    Oct 2003
    Posts
    33
    ok, my mistake.

Posting Permissions

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