DSXchange

Source of my job is SQL server table.It has a column whose datatype is Longvar binary (length-214748364).
The target table is oracle 9i.I am creating the table from job with same datatype.
The table is getting created with datatype LongRaw.But The job is getting aborted with error "Oracle datatype not presently supported".

Is datastage 7.5.2 not able to handle longvar binary?
Please suggest.

LongVarBinary is not a supported data type.

In particular, it's complaining about the Oracle LongRaw datatype not being supported.

Thanks for the info.

I can't help with the SQL Server question about LongVarBinary support. For the Oracle side, however, I would definitely avoid LONG or LONG RAW datatypes. They're really something you were stuck with in Oracle7 but since then have been deprecated and one should now use the 'new' LOB fields, introduced in 8i and enhanced since then.

Lots of information out there on the subject. Here's one such example that I Googled up. Hope it helps.