Page 1 of 2 12 LastLast
Results 1 to 15 of 18

Thread: Can't drop view

  1. #1
    Join Date
    Mar 2010
    Posts
    5

    Unhappy Unanswered: Can't drop view

    Hi to all!
    I have installed DB2 9.7 FP1 on AIX OS. I have activate ORACLE COMPATIBILITY
    If i try drop view DB2 give me this response:

    DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=HCSUITE.SQL100308144713000, DRIVER=3.50.152
    Message: "HCSUITE.SQL100308144713000" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.50.152 

    but the "HCSUITE.SQL100308144713000" i haven't create and i can not drop it.

    Can you help me please?

    Thanks.
    D.

  2. #2
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Why do you think it's a view?
    ---
    "It does not work" is not a valid problem statement.

  3. #3
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    What is the problem? It tells you that object you are trying to drop is not there in plain English.

    BTW. I have never seen that naming convention used in the views. That resembles a PK that was auto created.

    Run the following and post output.

    db2 list tables for all | grep -i SQL100308144713000

    I bet it will come back empty.

    db2 "select indname, uniquerule from syscat.indexes where indname = 'SQL100308144713000'"
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  4. #4
    Join Date
    Mar 2010
    Posts
    5
    this command

    Quote Originally Posted by Cougar8000 View Post
    db2 list tables for all | grep -i SQL100308144713000

    I bet it will come back empty.
    return empty

    Quote Originally Posted by Cougar8000 View Post

    db2 "select indname, uniquerule from syscat.indexes where indname = 'SQL100308144713000'"
    this statement retunt empty.
    When i tried to recreate view "create or replace view ...."

    DB2 give me this error:

    [Error] Script lines: 1-20 -------------------------
    DB2 SQL Error: SQLCODE=-901, SQLSTATE=58004, SQLERRMC=unable to retrieve function pd, DRIVER=3.50.152
    Message: The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "unable to retrieve function pd".). SQLCODE=-901, SQLSTATE=58004, DRIVER=3.50.152 

    I tried to catalog and found that the only point in citing that function is in the view syscat.ROUTINEDEP...

    have you any idea?

  5. #5
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1
    Apparently, in your view definition you attempt to use a function named "pd", which is not implemented properly in the database.
    ---
    "It does not work" is not a valid problem statement.

  6. #6
    Join Date
    Jul 2009
    Location
    NY
    Posts
    963

    Wink

    Quote Originally Posted by danieles View Post
    Hi to all!
    I have installed DB2 9.7 FP1 on AIX OS. I have activate ORACLE COMPATIBILITY
    If i try drop view DB2 give me this response:

    DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=HCSUITE.SQL100308144713000, DRIVER=3.50.152
    Message: "HCSUITE.SQL100308144713000" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=3.50.152 

    but the "HCSUITE.SQL100308144713000" i haven't create and i can not drop it.

    Can you help me please?

    Thanks.
    D.
    Nomastei ! Show your query, before show the error. Could be funny.

    Lenny

  7. #7
    Join Date
    Nov 2005
    Location
    IL
    Posts
    557
    Show us the DDL that you are trying to run.

    return empty
    If I give you ZERO dollars. How much bread can you buy with it?
    --
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows

    DB2 v9.7.0.6 os 6.1.0.0

  8. #8
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367

  9. #9
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by Cougar8000 View Post
    If I give you ZERO dollars. How much bread can you buy with it?

    If depends on where you're.

  10. #10
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by danieles View Post
    DB2 give me this error:

    [Error] Script lines: 1-20 -------------------------
    DB2 SQL Error: SQLCODE=-901, SQLSTATE=58004, SQLERRMC=unable to retrieve function pd, DRIVER=3.50.152
    Message: The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "unable to retrieve function pd".). SQLCODE=-901, SQLSTATE=58004, DRIVER=3.50.152 

    -901 could be a db2 bug

  11. #11
    Join Date
    Jul 2009
    Location
    NY
    Posts
    963

    Question

    Quote Originally Posted by db2girl View Post
    -901 could be a db2 bug
    Can you guess what is the country in the world produce the maximum number of "DB2 BUGS" ?

    Lenny

  12. #12
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    This is a very tough question to answer...

  13. #13
    Join Date
    Jul 2009
    Location
    NY
    Posts
    963

    Talking

    Quote Originally Posted by db2girl View Post
    This is a very tough question to answer...
    I guess: you knew !

    Lenny

  14. #14
    Join Date
    Jul 2009
    Location
    NY
    Posts
    963

    Talking

    Quote Originally Posted by db2girl View Post
    This is a very tough question to answer...
    Guess in old guess is new !

    Lenny

  15. #15
    Join Date
    Aug 2008
    Location
    Toronto, Canada
    Posts
    2,367
    Quote Originally Posted by Lenny77 View Post
    Guess in old guess is new !
    Sorry, no capish

Tags for this Thread

Posting Permissions

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