No.
And at the same time yes.
An ETL tool provides transformation, and there's no transformation you can do to a BLOB (or CLOB).
DataStage does not directly support binary datatypes (of which BLOB is but one example) but, if you encode it in a text-based encoding, such as uuencode, then you can use DataStage to transmit it.
Whether or not the BLOB format for Oracle is the same as the BLOB format for DB2 is not a DataStage issue - it's yours.
----- Original Message -----
From: bipul sarkar
Date: Tue, 16 Dec 2003 14:23:45 -0800 (PST)
To: datastage-users@oliver.com
Subject: Accesing 'BLOB' field in Oracle
> Hi All,
>
> I have a requirement of accessing a 'BLOB' field in
> oracle and dumping the data in DB2 ‘BLOB’ field and
> Vice-Versa. Is it possible to do this stuff using
> DataStage?
>
> Thanks & Regards,
>
> Bipul
>
>
> __________________________________
> Do you Yahoo!?
> Free Pop-Up Blocker - Get it now
> http://companion.yahoo.com/
>
Accesing 'BLOB' field in Oracle
Accesing 'BLOB' field in Oracle
<b>PLEASE READ</b>
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.