Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Posts
    63

    Unanswered: Non existing table showing in syscat.tables

    Hi,

    This is for version 8.1 on 4 logical partition system on AIX.
    I have this tables called DB.TAB_usrt that show up in syscat.tables and sysibm.systables. Also db2 list tables for all shows this table exist.
    This is not a view. Its a table.

    But when I try to drop this table it give me following error :
    SQL0204N "DB.TAB_usrt" is an undefined name. SQLSTATE=42704

    Also db2look doesn't generate any ddl for this table.
    I have updated stats on all tables including system tables. But problem still exists.

    Is anything currupt here? Why syscat.tables show up this non existing table?

    Thanks for help,
    toby

  2. #2
    Join Date
    Apr 2004
    Posts
    54
    Could you supply the entire script that produce suche error?...

  3. #3
    Join Date
    Oct 2005
    Posts
    109
    If you used

    CREATE TABLE "DB.TAB_usrt"
    ...

    you also have to use

    DROP TABLE "DB.TAB_usrt"

    DROP TABLE DB.TAB_usrt or Select * from db.tab_usrt would not be matched since internally it will look for DB.TAB_USRT.

    Otherwise: if the table was created using

    CREATE TABLE DB.TAB_USRT (capital or small characters don't matter as long as "" is not used)

    then also drop it this way:

    DROP TABLE DB.TAB_USRT

    Advice: don't mix large and small characters using ""
    Juliane

Posting Permissions

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