Text/Long Varchar Problems

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Text/Long Varchar Problems

Post by admin »

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
Locked