DSXchange

I am sourcing the data from sybase which contains a varbinary feild ,While compiling I am getting an error varbinary dataype not supported does the data stage supports varbinary?
I had to use bintostr() fn in the sql and that data type to varchar ,Its working but I am not sure how to change it back to binary ,I tried to use the tranformer fn stringtoraw() but I think its not properly converting it back to binary .
Any suggestions
Thanks
Arif

Hi Arif,

Everything I have seen and read on this site so far leads me to believe that binary is not generally supported. In some ways this makes sense as you can't perform any Transform functions on this type of data. On the other hand, if a database table happens to have a datatype of Text for one field (which is technically not binary - just big), that doesn't mean I don't want to get the other fields in the table from source to target without modifying the Text field. Anyway, I think that is the correct answer to your question.

Bestest!

mab_arif16 wrote:While compiling I am getting an error varbinary dataype not supported does the data stage supports varbinary?

Isn't it obvious from the message?

ray.wurlod wrote:

mab_arif16 wrote:While compiling I am getting an error varbinary dataype not supported does the data stage supports varbinary?

Isn't it obvious from the message?

Why does the datastage has it then

Reserved for future use? Also, the list of SQL data types is those decreed by the SQL 92 standard.

ray.wurlod wrote:Reserved for future use? Also, the list of SQL data types is those decreed by the SQL 92 standard.

If we use stringtoraw fn in transformer what data type the string gets converted to .
Thanks
Arif

Raw