Text/Long Varchar Problems
Posted: Fri Dec 14, 2001 3:14 pm
We have recently installed Datastage 4.2.1, and are using it to convert data from Sybase to Oracle Databases. I am having problems pulling text fields from Sybase into Datastage. Datastage is converting the field to a Long Varchar, but when I try to view the data, I get an error message stating that:
DSBrowser1: SQL data type LongVarChar defined on column WO_RprtText is not supported.
DSBrowser1.DSLink1: DSP.Open GCI $DSP.Open error -2.
We called this concern into support, and they said Datastage does not support Sybase text fields. Has anyone encounted this problem, and if so, how did you work around it?
Any help would be greatly appreciated.
Thanks!
Angela
DSBrowser1: SQL data type LongVarChar defined on column WO_RprtText is not supported.
DSBrowser1.DSLink1: DSP.Open GCI $DSP.Open error -2.
We called this concern into support, and they said Datastage does not support Sybase text fields. Has anyone encounted this problem, and if so, how did you work around it?
Any help would be greatly appreciated.
Thanks!
Angela