Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2004 @ 18:42:12 GMT

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

this is how to dynamically change the heading contents during the course of a query using bteq :

.set pagebreak on 1;
.set omit on 1;
.set heading 'YTD PURCHASES FOR CUSTOMER &1';

SELECT CUSTOMER_NAME,
       ....
FROM PURCHASES_TABLE

note especially the "&1" in the heading - this tells teradata to substitute in the VALUE of the first column that is at the top of the page the heading is going to print on. the pagebreak ensures that only a given customers data is on any given page and the omit ensures that the customer's name does not unnecessarily appear in both the data as well as in the heading.

thanks for the suggestion, but that still won't work. the split out utility i am using looks for the customer in the first line of the heading.

thanks,

-scott t.

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