Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Dec 2002 @ 18:17:09 GMT


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


Subj:   Re: Fast Export - Blank line
 
From:   Dwight Etheridge

TARUN,

I've experienced the same thing. The final result of your field concatenation is VARCHAR. Fexp writes it out with a leading 2 byte binary length value. When that binary value is just right, it produces the random line feeds that are screwing up your export file. So, you need to do a final cast into a char() like so:

 (c1 || c2 || c3 ) (char(n))  -- when n is big enough to cover the longest row.

This will eliminate the 2 byte binary length value, and make a fixed width file.



     
  <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