Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004
    Posts
    6

    Unanswered: How to convert BLOB data to LONG VARCHAR

    I have a blob column in a table, due to which I am not able to updrage from DB2 7.x to 8.x. The bug is "[IBM][CLI Driver] CLI0112E Error in assignment".

    Please refer http://www-1.ibm.com/support/docview...id=swg1IY43456

    Now, I woluld like to change the column data type from blob to long varchar.

    My problem is how to convert the existing blob data into long varchar, the data stored in blob was only text.

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    long varchar

    if this is an odbc source you can add this to db2cli.ini in \sqllib
    LONGDATACOMPAT=1
    This will convert data to long varchar..
    Best Regards, Guy Przytula
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Sep 2004
    Posts
    6
    Oops, I would like to do this using sql script only.

Posting Permissions

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