I have created an error table for my table, so that the DML statements doesn't abort; the bad row (rows which could not be inserted/updated in my table due to reasons such as bad format in a column or any constraint etc.) gets inserted in the error table.
Please check the link below to have a better understanding of what I am trying to say:

Hi,
We have some jobs loading data from TPT which creates ET for duplicate records.
Does anyone know how to convert Hostdata values into actual record from ET? I have limitations, can not user fastexport or Varbyte2Varchar UDF.

I need to store the value in the DataParcel column(which is of VARBYTE datatype) in the first error table of FASTLOAD into a permanent teradata table but with a proper format(The ddl of this table will be exactly the same as the target table, except that all datatypes are varchar)
I know this as a potential solution/*From teradata manual*/:

Hi,
I am using a fastload script to load data to my tables.
The error table created has 3 columns:
ErrorCode INTEGER FORMAT 'ZZZZ9',
ErrorFieldName VARCHAR(30) CHARACTER SET LATIN NOT CASESPECIFIC,
DataParcel VARBYTE(64000)