Accesing 'BLOB' field in Oracle
Posted: Tue Dec 16, 2003 5:22 pm
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/
>
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/
>