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
Are you aware that the DRS stage documentation, on pages 29 and 30, do not contain LONGVARCHAR as a valid Sybase data type? You will have to redefine this as a CLOB.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
My Bad......
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
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