While fastexporting from a table to a text file in record mode, i am getting "The string contains an untranslatable character" error.In my fastexport, i am casting a decimal field to BIGINT and its causing this error.As soon as i change the casting from decimal to varchar, its working amazingly fine.Below is the DDL for my source table and the Fastexport script i am using.Also, the target is a default ASCII character set, so no issues with that:
When i change TRIM(CAST(SRCID AS BIGINT)) to TRIM(CAST(SRCID AS VARCHAR)) & TRIM(CAST(DIAG_CD_ORDR_NBR AS BIGINT)) to TRIM(CAST(DIAG_CD_ORDR_NBR AS VARCHAR)), its giving no error and working fine....
format "text" is used for character data types like CHAR, VARCHAR, LONG VARCHAR etc. What you are doing here is exporting integer data types in text format. While this scenario will work in some cases but it is not recommended to use TEXT format for integer data types.
See FastExport manual for details. Here is what it says:
Note: TEXT format should only be specified for character data. Do not
specify TEXT format for binary data, such as, INTEGER, BYTEINT,
PERIOD, and other binary data. Depending on the actual byte values of
the binary data, unexpected results may occur.