In order to see the chinese/japanese characters, you MUST specify either UTF8 or UTF16 as the character set in the script.
If you specify UTF8, you must triple the size of the character fields (CHAR, VARCHAR).
If you specify UTF16, you must double the size of the character fields (CHAR,VARCHAR).
I have mentioned UTF8 and tripled the size of the unicode fields, i still get the following error.
In the example script you sent, EmpCatNumber was defined in the table as VARCHAR(10).
If that is the case, then the script must specify VARCHAR(30).
If this is done correctly, I am not sure how TPT could think that the target column's data length would be 90.
What version of TPT are you running?
I have changed the empcatnumber to 30. I even tried increasing the size to 60/90 but the error meesage remains the same.
My TPT version is Teradata Parallel Transporter Version 15.10.01.02 64-Bit.
Can you please help me understand if we need to make any system wide property defined for having handling unicode exports.
You must triple the VarChar size in your Export Schema, not in your Select.
Additionally you don't need to specify a schema at all, when the Format is DELIMITED, and your Select can be a simple
SELECT * (unless you want to use a specific Format for the cast), as typecasts to varchar are done automatically.