Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Jul 2004 @ 12:08:45 GMT


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


Subj:   Re: Eliminating Column Titles during a FastExport
 
From:   Dieter Noeth

Anomy Anom wrote:

  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.  


A FastExport never writes a column header.


     > .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

This is a BTEQ Export.

There are two ways to get rid of the header:

- you add a (TITLE '') to each column in your select list

- you specify "EXPORT DATA" instead of "EXPORT FILE" and add a "SET RECORDMODE OFF" before the select. This switches back to Report format and omits the header, but is undocumented behaviour.


Btw, in the newest release of BTEQ (8.2.1 Win32) RECORDMODE is back again, so no more limit of 254 chars. It's neither in the manuals nor shown by ".HELP BTEQ" but BTEQ accepts it and it works ;-)


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