I know this post was back in 2006, but I'm really in search of a UDF or some method within teradata to convert varbyte to varchar. So I'm hoping you guys can help me out.
My primary objective is to store all rows in the error table of fastload into a persistent error table(its ddl matches with that of the target table but all fileds are varchar)
I could do the method of exporting the records of error table into the client system and read them back again into a table with all varchar but all of this seems unnecessary(and franky quite crude) to me.
I'd like a method to keep the record within teradata itself and achieve this objective. We're on TD 13.10.