loading images

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
krisna
Participant
Posts: 77
Joined: Tue Apr 08, 2008 11:33 pm

loading images

Post by krisna »

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.....
Top
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Contact ray.wurlod

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Top
Post Reply

Return to “IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)”