Clob field with Schema file

kottinaresh · Post by **kottinaresh** » Wed Mar 16, 2016 8:11 am

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

ray.wurlod · Post by **ray.wurlod** » Wed Mar 16, 2016 6:54 pm

Don't enable RCP.

kottinaresh · Post by **kottinaresh** » Wed Mar 16, 2016 9:30 pm

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

Thanks,
Naresh K.

priyadarshikunal · Post by **priyadarshikunal** » Tue Mar 29, 2016 3:13 am

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