Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 16 Jan 2003 @ 15:03:13 GMT


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


Subj:   Re: Column titles and titledashes should not appear in the export file.
 
From:   Craig Windland

Here is another way using fast export. You can imbed this in a shell script and cat the created file.

Personally, I don't know of a method that places only data to standard out. Teradata needs to work on this!

Personally, I find this superior to the bteq method.

.logtable  LOGTABLENAME;

.logon database/uid,pwd

.begin export
   sessions 20;

.export  outfile FILE.DAT format text;

select
       CAST(COL1 AS CHAR(99) )
      ,CAST(COL2 AS CHAR(99)  )
      ,CAST(COL,etc AS char(99))

from database.table
where WHERE PREDICATE CONDITION
sample 99;

.end export;

.logoff;


     
  <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