Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2004 @ 20:01:00 GMT


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

Subj:		Re: How to print heading one time only in a BTEQ query?

From:		Scott Thompson

Although not elegant, what if you set titles to NULL ('') and page breaks off, you will have no titles or page breaks, just a blank row at the beginning of the output. Then type the titles once after entering the data in Excel.

thanks for the suggestion Bill, but this would be impractical for my application as this is to be an automated process that will perform the query, split out the reports, and ftp them to a remote customer service location where it will be forwarded to the various customers for upload in excel. the number of files produced will be dynamically determined by the number of customers who will be getting a report in a given timeframe. i can't accept that a piece of technology as sophisticated as teradata/bteq does not have a method to accomplish what i am trying to do in an automated manner (i.e. limit headings to just 1 per report, or at least 1 per page where a page can be over 32767 rows long).

thanks,

-scott t.