Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 30 Dec 2003 @ 14:38:36 GMT


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


Subj:   Re: Teradata Bteq Heading Formatting Question
 
From:   Scott Thompson

Well actually, that is what i am doing. here is my export statement along with a few others (i am on an MVS platform) :

/*******************************************************/
.SET FORMAT ON;
.SET FORMCHAR '0C'XB;
.SET PAGELENGTH 32767;
/*******************************************************/
.SET SEPARATOR " ";
.SET ECHOREQ ON;
.SET SIDETITLES OFF;
.SET WIDTH 240;
.EXPORT REPORT DDNAME=outdata;
/***********************************************************/

the report is exported to a file and then ftp'd to a user at a remote location who is opening it up using excel. as stated originally, a new heading appears after every 32767 rows (this number is the max that my system will allow me use for pagelength).

is there some other way i can suppress all except the first heading, no matter how many rows are returned ?

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: 23 Jun 2019