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


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: 23 Jun 2019