Sybase 'Text' data type compatibility problem.

anshumangupta1206 · Post by **anshumangupta1206** » Thu Jul 19, 2007 12:25 am

Hello All,

I have one sybase table which contains one of the field having a datatype as 'Text'. I am using Sybase OC as a connective, while insertion of data into 'Text' field I am getting an error message as'

' Sybase Server warning 2782 (severity 16) from stored procedure 'Input_0', line 1: An untyped variable in the PREPARE statement 'Input_0' is being resolved to a TEXT or IMAGE type. This is illegal in a dynamic PREPARE statement. '

In Sybase OC we don;t have any datatyps called as 'Text', so I tries Varchar, Char, LngVarchar but same error is occuring.

Can help me to sort the problem.

Maveric · Post by **Maveric** » Thu Jul 19, 2007 12:31 am

See if this link helps.

viewtopic.php?t=111557

That is for parallel job. but see if you can use it.

chulett · Post by **chulett** » Thu Jul 19, 2007 12:33 am

The Sybase OC stage does not support the Text datatype. Not sure what, if any, work-around exists. And unfortunately, there's no solution in that linked post either. At least not yet.

anshumangupta1206 · Post by **anshumangupta1206** » Thu Jul 19, 2007 12:42 am

I tried all the solutions given, but not succeeded yet

Maveric wrote:See if this link helps.

viewtopic.php?t=111557

That is for parallel job. but see if you can use it.

chulett · Post by **chulett** » Thu Jul 19, 2007 6:51 am

As noted, that would be because no solutions have been given. Contact your official Support provider, see what they say your options are.

Your 'work-around' may very well be to do this outside of DataStage using Sybase command line tools via a script, for example. Of course, DataStage could run / monitor that script for you...