Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 10 Feb 2000 @ 05:56:48 GMT


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


Subj:   Re: BTEQ Sentences
 
From:   Barbara George

  I'm using the following BTEQ SCRIPT to obtain a flat file. This script returns a file with the name of the columns used in the select sentense as the header.  


  What setting or additional sentece should I use to avoid the header in the output file? Additional, this header appears every certain number of lines as a page break. I'm looking for a solution to avoid all the headers.  



I have found using the 'title' phrase with an empty string eliminates the heading for a column, eg:

     SELECT CodProducto (title ''), .....   etc

There is probably a quicker and better way to do this, but my output file had only 1 column, and this worked.


Barbara George
Manager, Decision Support, Pick 'n Pay Information Systems
Cape Town, South Africa



     
  <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