DSXchange

Yes. If an Oracle varchar2 column is defined with a length of 4000, then the updates work correctly if the DataStage length is less than 4000.

We are using the server edition, but we just ran into this same issue this morning. If you do a "select dump(column) from table" you can see what is actually in the column. Our job is defined as follows: DS job column definition as VARCHAR 4000, Oracle column definition as VARCHAR2(4000), ...