'CS_TEXT_TYPE' not supported

Paddy_McD · Post by **Paddy_McD** » Fri Jan 19, 2007 1:59 am

Can anyone tell me if there is a way around this :
Dynamic_RDBMS_36: Sybase data type 'CS_TEXT_TYPE' for column 'AAAA' is not supported

Thanks.

chulett · Post by **chulett** » Fri Jan 19, 2007 7:42 am

Welcome aboard, Paddy. :D

Before we go any further with this, can we verify your 'particulars' that you marked your post with, please? There is no 6.x version of EE where parallel (PX) jobs will run on a Windows server, so could you let us know what those values should really be?

Thanks. It will help get us on the right path more quicker.

Paddy_McD · Post by **Paddy_McD** » Fri Jan 19, 2007 7:46 am

[quote="chulett"]Welcome aboard, Paddy. :D

Before we go any further with this, can we verify your 'particulars' that you marked your post with, please? There is no 6.x version of EE where parallel (PX) jobs will run on a Windows server, so could you let us know what those values should really be?

Thanks. It will help get us on the right path more quicker.[/quote]

Thanks - Release 7.5.1.A

chulett · Post by **chulett** » Fri Jan 19, 2007 8:04 am

Ok, more please. What operating system is your DataStage server installed on? That's what the "OS" question was asking. For that version it must be some flavor of UNIX, not Windows if you are working with Parallel jobs. You are asking about a parallel job, aren't you?

ps. No need to quote the entire post you are replying to, a simple reply will do.

kcbland · Post by **kcbland** » Fri Jan 19, 2007 8:07 am

It seems the Sybase functionality doesn't support a datatype. Sometimes we're successful by changing the metadata to one closely compatible and hoping that it will work. Sometimes a CLOB datatype can be gained with VARCHAR, provided the data is small.

I think with PX you're going to have a tough time because of the absolute data typing that occurs. Maybe you could give us some information about this particular columns datatype, as the "not supported" seems fairly clear as far as usability.

DSguru2B · Post by **DSguru2B** » Fri Jan 19, 2007 9:48 am

I think the driver that is being used is not compatible with that data type. I think you need to get in touch with support and get a patch or a workaround.

us1aslam1us · Post by **us1aslam1us** » Fri Jan 19, 2007 11:50 am

If you are using sybase 12.5 version then there is a patch available for that. Contact your provider.