Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2009
    Posts
    2

    Unanswered: Orphaned table in systables?

    We had a table create in both upper case and lower case (temp_rob and TEMP_ROB). We did a drop able on TEMP_ROB. temp_rob still shows in the systables and syscat.columns.

    This causes issues in another applicaiton that reads these tables and looks for permissions on those tables. It failts because any attempt at a drop or select on temp_rob results in

    "Error 09/01/2009 13:43:17 0:00:00.000 DB2 Database Error: ERROR [42704] [IBM][DB2/NT64] SQL0204N "LYNX.TEMP_ROB" is an undefined name. SQLSTATE=42704"

    Any thoughts on how we can remove temp_rob from system tables?

    Thanks!

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Quote Originally Posted by robbay
    any attempt at a drop or select on temp_rob results in

    "Error 09/01/2009 13:43:17 0:00:00.000 DB2 Database Error: ERROR [42704] [IBM][DB2/NT64] SQL0204N "LYNX.TEMP_ROB" is an undefined name. SQLSTATE=42704"
    I see an attempt to access "TEMP_ROB", not "temp_rob". Case sensitive object names should be enclosed in double quotation marks.
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Sep 2009
    Posts
    2
    Nick.

    I noticed that as well. Your suggestion worked perfectly. Using drop table "temp_rob" allowed me to drop the table.

    Life is wonderful.

    Thanks very much.

Posting Permissions

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