Unanswered: how do you import a blob column from Sql server 2000 to UDB 8.1
I am undergoing a migration excercise from SQL SERVER 2000 to UDB DB2 8.1
We have some tables in SQL SERVER which are BLOB and VARBINARY.
What would be good way to extract that data from SQL SERVER and load it into DB2.
I tried using BCP at the sql server end to export the data from the tables and then I used an import at the DB2 end to load the data in.
The import was successful but then the import also added a few characters to the BLOB datas.