DSXchange

Hi,
I have a situation- Loading data from file(Fixed width) -->Tfm--> Oracle.

There is a field with 600kb record size.

In oracle it is defined as CLOB. So, using LONGVARCHAR in datastage i'm able to load into Oracle successfully, changing some env variables to handle the size of the data.

Now, When doing the same using "RCP - enabled & Schema file" with Field datatype as "string" in Schema file, the job is finishing fine with now warnings, but the data that is being loaded in this case is a truncated one with length of the record as 10176 instead of the acutal length 600000.

Any suggestions please..

Thanks,
Naresh K

Don't enable RCP.

Ray, you mean- we should go with Custom job with metadata defined instead of a generic one?

Thanks,
Naresh K.

That is a Yes. And keep clob as last column.