Archives of the TeradataForum
Message Posted: Wed, 20 Nov 2002 @ 05:31:27 GMT
| Subj: | | Fast Export - VARCHAR concatenation |
| |
| From: | | Tarun Neelam |
Hello
I need to Fast Export a data file which is pipe delimited, to achive this I normally concatenate the columns that I am retriveing by
using the concatenation Operator, '||' & casting all the columns to char data type.
The last time when I had to extract a VARCHAR data type columns along with other columns with different data types all casted to char
data type i was getting an error '6706 The string contains an untranslatable charecters' but when when I tried extracting all the VARCHAR
columns seperately after casting them as char data type I did not get any error. Could you let me know what is going wrong or is there any
other way to over come this problem.
Thanking you
TARUN
| 
