Archives of the TeradataForum
Message Posted: Wed, 24 Mar 2004 @ 13:43:13 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|