Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Dynamic Title for Bteq Report
 
From:   Scott Thompson

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>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016