User Profile

Collapse

Profile Sidebar

Collapse
28days
28days
Last Activity: Nov 19 '08, 03:35 PM
Joined: Aug 18 '08
Location: dublin
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • 28days
    replied to SQL0440 error on delete statement
    in DB2
    Futher to this issue, i executed the following sql,
    ---------------------------------------------------------------------
    What this does
    1. Attempt delete from table (returns SQL0440)
    2. Drop Foreign Key (child of table in error)
    3. Attempt delete from table (works ok)

    delete from XXXXX.PERYYYYY where PERYYYYY_KEY = 99999999

    DB21034E The command was processed as an SQL statement...
    See more | Go to post

      Leave a comment:

    • 28days
      replied to SQL0440 error on delete statement
      in DB2
      Thanks Spider007

      Not sure if the DB was migrated when moving to V9. I assume that when you say migrated, this is NOT the same as restoring a DB onto a later version of DB2??...
      See more | Go to post

        Leave a comment:

      • 28days
        started a topic SQL0440 error on delete statement
        in DB2

        SQL0440 error on delete statement

        HI,

        The following SQL statement returns an error SQL0440, complaining about routine '=' not found

        delete from XXX.YYYYY where YYYY_key = 99999

        > The database containing the table was restored from a Db2 V8 on one machine to V9 on a different machine (this happens on both Windows/)

        > Various SQL ALTER scripts where run tables around this table e.g ALTER adding foreignKey with...
        See more | Go to post
        No activity results to display
        Show More
        Working...