How to convert BLOB data to LONG VARCHAR

sridharaswamy · #1 (**permalink**) 01-31-05, 02:01

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.

przytula · #2 (**permalink**) 01-31-05, 12:45

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

sridharaswamy · #3 (**permalink**) 02-01-05, 04:14

Oops, I would like to do this using sql script only.

Internet Services

Web Development

Digital Marketing

Consumer Tech