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
Varbinary error
Moderators: chulett, rschirm, roy
Re: Varbinary error
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!
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!
Bestest!
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
John Miceli
System Specialist, MCP, MCDBA
Berkley Technology Services
"Good Morning. This is God. I will be handling all your problems today. I will not need your help. So have a great day!"
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Varbinary error
Isn't it obvious from the message?mab_arif16 wrote:While compiling I am getting an error varbinary dataype not supported does the data stage supports varbinary?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Charter Member
- Posts: 87
- Joined: Sat Mar 18, 2006 11:45 pm
Re: Varbinary error
Why does the datastage has it thenray.wurlod wrote:Isn't it obvious from the message?mab_arif16 wrote:While compiling I am getting an error varbinary dataype not supported does the data stage supports varbinary?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Charter Member
- Posts: 87
- Joined: Sat Mar 18, 2006 11:45 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: