How to Enter more than LongVarchar (4000) in DataStage

[pavans]

Hi,

I am facing one problem that is

in orcale database we are using CLOB datatype

now when i import metadata into datastage it will take LongVarchar(4000) only.

now i changed this length inot LongVarchr(20000) in datastage and i ran the job still it was support only 4000 remining characters are trimming.

I need to put a value of 20,000 charcaters inside a column using DataStage but I am unable to do so.

it is a showstopper for my project so please explain me clearly because i am new to datastage

ThankYOu.