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