Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Jul 2004 @ 11:39:39 GMT


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


Subj:   Eliminating Column Titles during a FastExport
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, July 20, 2004 06:59 -->

We are trying to export a small table to an output file, which works fine, however, the job also writes Column Titles to the file, which we do not want. Please can someone tell us how to prevent this. We cannot find reference to it in the manuals.

(I know we could just ignore the first row of the file, but can we get rid of them from the export?)

     .EXPORT REPORT FILE=@OUTPUT_LST@
     .Set SideTitles Off;
     .Set Echoreq Off;
     .Set Width 254;
     .Set TitleDashes Off;

     Select  *
     from @ACCESS_DB@.SYS_PASSWORDS
     where   User_group = 'MSTR'
     and     last_changed_date <  current_date - 90;

     .LABEL End;

     .EXPORT RESET
     .Exit 0;


     
  <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: 27 Dec 2016