Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Fexp script to a CSV file
From:   Glen Blood

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


      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.


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023