Hi All,

this is urgent. Currently we are using Datastage server jobs. We need to migrate some data columns with column length 1500 to 2000 with Oracle 9i as target. We are not able to do this with simple ODBC stage as it seems it doesn't support length more than 500 chars. So we moved to DRS with DBMS Type as ODBC. But for some data it's not working and giving error like 'Right Truncation'. We tried with DBMS Type as Oracle also. It's giving problem too. Probably there is no proper server configuration for DRS with DBMS Type as Oracle. Please tell me how to configure server to use DRS with DBMS Type as Oracle.

Thanks,