DSXchange

Hi All,

Need to extract images from oracle and load to DB2. Please advise how can we achieve this.

In Source image column datatype is BLOB.

Thanks in advance.....

First question to ask is whether the Oracle BLOB and DB2 BLOB are compatible.

If they are, treat them as Long VarChar data type. Use appropriate CAST or conversion functions in user-defined SQL.