Home Page for the TeradataForum

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'')


  <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