Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 12 Nov 2004 @ 14:10:35 GMT


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


Subj:   Re: New to BTEQ
 
From:   David_Hagan

We use a command:

     cut -c4-    file1 >> file 2

to trim the leading lrecl.

For EXPORT REPORT FILE....... so you do not get dashes:

     .TITLEDASHES OFF         /* This will turn off the dashes */

Then to remove the column title, do something like

     select    firstname (title '')
     from employee;

So you could do

     .bteq
     .login abcde
     .TITLEDASHES OFF
     .EXPORT REPORT FILE=myfile
     select firstname (title '') from employee;

I don;t have an answer about the number of records supported.

Hope this helps!



     
  <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