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;

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

from database.table
sample 99;

.end export;


  <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: 28 Jun 2020