Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 03 Feb 2004 @ 21:34:44 GMT


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


Subj:   How to print heading one time only in a BTEQ query?
 
From:   Scott Thompson

hello,

i am running queries that may return a 100,000 or so rows using BTEQ batch, but i want only the first heading to print and no more (the file will ultimately be uploaded to EXCEL). i know about the .SET PAGELENGTH command, but the max i can specifiy on my platform is 32767. after i return 32767 rows, i get another heading with this. does anyone know of another way to limit the print of the heading to only the first one ?


thanks

-scott t.



     
  <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