Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2009
    Posts
    22

    Unanswered: migration of v8.2 to v 9.5.0.4

    i willl try to look it u p
    Last edited by sdsu; 01-18-10 at 15:29. Reason: sorry

  2. #2
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    Yes, the -206 indicates that the colimn in not known in the table. Thinks like this are always more easy in the db2-cli. Just connect and try the SQL. After that just type "db2 ? sql0206" and the error is explained.

  3. #3
    Join Date
    Dec 2009
    Posts
    22
    Hi dr_te_z,

    Thanks for the quick reply

    Can you let me what should be done ????

    Thanks in advance !!!!
    Last edited by sdsu; 01-18-10 at 15:30. Reason: i will see

  4. #4
    Join Date
    Jan 2009
    Location
    Zoetermeer, Holland
    Posts
    746
    What are you migrating? Just DB2 or a software package which uses DB2 and WAS? You have to go to the person or company who produces the SQL containing errors. This has nothing to do with migrating and everything with SQL and DDL.
    I suggest you go to the CLI and execute "db2 describe table mbreel". This will punch the DDL of the table. My 'guess' is that either the column "ordermsgs_id" or "sequence" is missing because they are the only ones mentioned in the "where" clause.

Posting Permissions

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