I have a Varbinary column at source side (Sybase) and a equivalent VARBYTE column at target side(Teradata).
I have the data extracted from source side into a flat file.
Now I need to load this data to Teradata.
I am using Teradata Parallel Transport (TPT) UPDATE Operator and I am getting error message:
3532 Conversion between BYTE data and other types is illegal.
I gone through all the TPT pdfs but don't see a way out. Please suggest if you have any idea.
Please provide the entire script so we can take a look.
It looks like the Teradata database is indicating that you are not specifying BYTE/VARBYTE in the schema properly.