Usage of Oracle BLOB thru' DataStage

[durgaps]

Hi,

I need to store a large data file in a BLOB column of an Oracle table using DataStage. Can somebody plz giv some leads on how to do it? Or some ref material will be equally good. I searched in the DataStage Online manual, but couldn't find any info regarding this.

Regards,

[kusuma]

Hi Durga,

I am not sure about storing BLOB columns in Oracle using DataStage, but I know we can read BLOB columns using DataStage. While creating the DSN, in the advanced options, Enable N-Char Support. And I remember using ODBC stage. Please try this, it might help you.

kusuma

[ksk]

Hi ,

Possible with datastage 8.1 version , using connector use the longvarbinary type in source same at the destination .

ksk