Archives of the TeradataForum

Message Posted: Wed, 19 Nov 2003 @ 17:10:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Unfortunately in fastexport, I have found that you have to select one of two additional steps:

either

select
      CAST(trim(first_name)   || ',' ||
      trim(last_name)   || ',' ||
     trim(coalesce(salary, 0)) || ',' ||
    trim(age) as CHR(254))

from tablea;

254 was selected arbitrarily, but it has to be as large as the longest string created. This method enables you to use the data directly.

or handle the variable length bytes (usually (but not always) 2 non ASCII bytes at the beginning of the line.). I have seen a number of solutions to problem.

Glen

	<Prev	Next>		<<First	<Prev	Next>	Last>>