I exported some byte data from DB2 into a flatfile (such x'00' x'20' x'08' ....). I tried in fixed length and delimited formats, but I was not able to load into a Teradata byte column using MLOAD. The byte data when exported to these files is a sequence of 13 characters. I used a delimiter which would not conflict with any of the byte data characters.
For the fixed length TEXT file, I defined the field as BYTE(13) in the layout, same size as the target table. When run, I get a error such as data in the file invalid for the byte colummn.
For the vartext delimited file, I defined the field as VARBYTE(13) in the layout, and I get an error such as "data is too short". It seems like MLOAD can't break up the record correctly.
Is the problem related to the non-standard text characters in the file? Should I use the unformatted format?