Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sat, 07 Aug 2004 @ 11:30:36 GMT


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


Subj:   Re: What's the BTEQ Syntax to Export Fixed-Field Text from Teradata Table for Cognos Transformer
 
From:   Dieter Noeth

Joseph Massena wrote:

  This is what I am using for csv but what's the syntax for fixed width with Column Titles? Any help greatly appreciated!  


     .set titledashes off;
     .set width 254
     .set separator '';
     .export report file = ...
     select ....
     .export reset

The maximum width is 254, so you hopefully don't need more than that... Only the newest release of BTEQ (8.2.1) knows REPORTWIDE up to 32K (or 64K?).


Dieter



     
  <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