Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 21 Feb 2005 @ 16:03:31 GMT


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


Subj:   Re: BTEQ - suppressing column headers
 
From:   Woodrow, Steven C

I think what you need to do is specify (title '') after each column selected as follows:

     .logon tdp0/dba;
     .set width 254;
     .set titledashes off;
     .set maxerror 0;
     .set errorout stdout;

     select ' database '||trim(:tdb)||';' (title '')
     ;select 'CREATE TABLE xxxxx (c1 VARCHAR(30),c2 VARCHAR(100),c3
     VARCHAR(5000),  c4 VARCHAR(30))' (title '')
     ;select 'PRIMARY INDEX (c1);' (title'')
     ;

Etc.



     
  <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