Archives of the TeradataForum

Message Posted: Wed, 24 Mar 2004 @ 13:43:13 GMT

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

Ramaswamy,

you can do it with a varient of the following code :

.set pagebreak on 1,2;
.set heading 'This report shows people in charge of areas//-
PERSON IN CHARGE: &1 || AREA: &2 '

select person,
       area,
       other columns from the table(s) .....

BTEQ "knows" to replace the '&1' in your heading with the first column specified in your select statement, the '&2' with the second and so forth. if you don't want to see the person/area on every row returned, you can also add a ".set suppress on 1,2;". if you don't want to see the person/area at all (except in the heading), you can instead add a ".set omit on 1,2;". even though you have omit turned on to these 2 columns,

bteq will still be able to "see" them and dynamically placed them into the heading.

hope this helps,

-scott t.

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