Hi,
As part of building my job, I need to extract data from Sybase and load it to Oracle. I'm using DRS stage to extract data from Sybase. One of the source column is of LongVarChar data type with size 214748364. With this i'm facing error as
" Error occurred during link open processing.
DSLink1: DSP.Open GCI $DSP.Open error -100."
When i reduced the size to 4000 in DRS stage, the job ran fine with data truncated.
Please help me how to extract the complete data in that field (214748364) and load it to oracle stage without any truncation.
Regards,
Balakrishna
Data truncation issue-Sybase Database
Moderators: chulett, rschirm, roy
My Bad......![Sad :(](./images/smilies/icon_sad.gif)
The approach i followed didn't worked.
ArndW,
My job is like extracting data from Sybase using DRS stage and directly loading to Oracle using Oracle Enterprise Stage. Except for these two, no other stages are used.
You told to redefine the datatype as CLOB.But when i did so, it gave me invalid datatype error.
Regards,
Balakrishna
![Sad :(](./images/smilies/icon_sad.gif)
The approach i followed didn't worked.
ArndW,
My job is like extracting data from Sybase using DRS stage and directly loading to Oracle using Oracle Enterprise Stage. Except for these two, no other stages are used.
You told to redefine the datatype as CLOB.But when i did so, it gave me invalid datatype error.
Regards,
Balakrishna