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.....
loading images
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
If they are, treat them as Long VarChar data type. Use appropriate CAST or conversion functions in user-defined SQL.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.