DSXchange

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.

See if this link helps.

viewtopic.php?t=111557

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

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.

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.

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...